Installation guide

7. mxODBC Cursor Objects
Column Name Column Datatype Comment
For numeric data types, the database can return a
NUM_PREC_RADIX of either 10 or 2.
NULLABLE SMALLINT not NULL SQL.NO_NULLS if the column does not 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(3) 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 ODBC3 SQL data type. This column is the same
as the DATA_TYPE column, except for date/time
types.
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 parameter column in
the procedure call. The first column has an
ordinal position of 1.
127