Go Up to Using Arrays
Arrays are defined with the
CREATE DOMAIN or
CREATE TABLE statements. Defining an array column is just like defining any other column, except that you must also specify the array dimensions.
Array indexes range from –231 to +231–1.
The following statement defines a regular character column and a single-dimension, character array column containing four elements:
EXEC SQL CREATE TABLE TABLE1 ( NAME CHAR(10), CHAR_ARR CHAR(10) );
Array dimensions are always enclosed in square brackets following a data type specification of a column.
For a complete discussion of
CREATE TABLE and array syntax, see Language Reference Guide.