Was this helpful?
iicolumns Catalog
For each querytable object in the iitables catalog, there are one or more entries in the iicolumns catalog. Each row in iicolumns contains the logical information on a column of the query object. The iicolumns catalog is used by user interfaces and user programs to perform dictionary operations and dynamic queries.
Column Name
Data Type
Description
table_name
char(256)
The name of the table. Must be a valid name.
table_owner
char(32)
The owner of the table. Must be a valid username.
column_name
char(256)
The column’s name. Must be a valid name.
column_datatype
char(32)
The column’s data type name returned to users and applications:
integer
smallint
int
float
real
double precision
char
character
varchar
c
text
date
money
decimal
user data types (UDTs)
For details on UDTs, see the Object Management Extension User Guide.
column_length
integer
The length of the column returned to users and applications. If a data type contains two length specifiers, this column uses the first length. Set to zero for the data types which are specified without length (money and date). This length is not the actual length of the column’s internal storage.
column_scale
smallint
The second number in a two-part user length specification; for typename (len1, len2) it will be len2.
column_nulls
char(8)
Y if the column can contain null values, N if not.
column_defaults
char(8)
Y if the column is given a default value when a row is inserted. N if not.
column_sequence
smallint
The number of this column in the corresponding table’s create statement, numbered from 1.
key_sequence
smallint
The order of this column in the primary key, numbered from 1. For a table, this indicates the column’s order in the primary storage structure key. If 0, then this column is not part of the primary key. This is unique if the unique_rule column for the table’s corresponding entry in iitables is set to U.
Sort_direction
char(8)
Defaults to A for ascending when key_sequence is greater than 0. Otherwise, this value is a blank.
Column_ingdatatype
smallint
Contains a value that indicates the data type of the column. If the value is positive then the column is not nullable; if the value is negative, then the column is nullable. The data types and their corresponding values are:
integer -30/30
float -31/31
c -32/32
text -37/37
date -3/3
money -5/5
char -20/20
varchar -21/21
decimal -10/10
Last modified date: 12/14/2023