Installation guide

7. mxODBC Cursor Objects
Column Name Column Datatype Comment
accept NULL values.
REMARKS VARCHAR(254) May contain descriptive information about
the column or NULL.
It is possible that no usable information is
returned in this column (due to
optimizations).
COLUMN_DEF VARCHAR(254) The column's default value. If the default
value is a numeric literal, then this column
contains the character representation of the
numeric literal with no enclosing single
quotes. If the default value is a character
string, then this column is that string
enclosed in single quotes. If the default value
a pseudo-literal, such as for DATE, TIME,
and TIMESTAMP columns, then this column
contains the keyword of the pseudo-literal
(e.g. CURRENT DATE) with no enclosing
quotes.
If NULL was specified as the default value,
then this column returns "NULL". If the
default value cannot be represented without
truncation, then this column contains
"TRUNCATED" with no enclosing single
quotes. If no default value was specified,
then this column is NULL.
It is possible that no usable information is
returned in this column (due to
optimizations).
SQL_DATA_TYPE SMALLINT not NULL SQL data type. This column is the same as
the DATA_TYPE column.
SQL_DATETIME_SUB SMALLINT The subtype code for datetime data types:
SQL.CODE_DATE, SQL.CODE_TIME,
SQL.CODE_TIMESTAMP. For all other data
types this column returns NULL.
CHAR_OCTET_LENGTH INTEGER Contains the maximum length in octets for a
character data type column. For Single Byte
character sets, this is the same as
COLUMN_SIZE. For all other data types it is
NULL.
ORDINAL_POSITION INTEGER not NULL The ordinal position of the column in the
table. The first column in the table is number
1.
IS_NULLABLE VARCHAR(254) Contains the string "NO" if the column is
known to be not nullable; and "YES"
117