Installation guide

7. mxODBC Cursor Objects
The method is useful to determine columns that can be used as to determine
query columns that allow retrieving rows which have been inserted in a table
without primary key or in a table with a primary key which is defined as auto-
increment column.
The catalog method generates a result set having the following schema:
Column Name Column Datatype Comment
SCOPE SMALLINT The duration for which the name in
COLUMN_NAME is guaranteed to point to the
same row. Contains one of the following
values: SQL.SCOPE_CURROW,
SQL.SCOPE_TRANSACTION,
SQL.SCOPE_SESSION.
COLUMN_NAME VARCHAR(128) not
NULL
Name of the column that is (or part of) the
table's primary key.
DATA_TYPE SMALLINT not NULL SQL data type of column identified by
COLUMN_NAME.
TYPE_NAME VARCHAR(128) not
NULL
Character string representing the name of the
data type corresponding to DATA_TYPE.
COLUMN_SIZE INTEGER If the DATA_TYPE column value denotes a
character or binary string, then this column
contains the maximum length in characters for
the column.
For date, time, timestamp data types, this is the
total number of characters required to display
the value when converted to character.
For numeric data types, this is either the total
number of digits, or the total number of bits
allowed in the column, depending on the value
in the NUM_PREC_RADIX column in the result
set.
BUFFER_LENGTH INTEGER The maximum number of bytes for the
associated C buffer to store data from this
column if SQL.C_DEFAULT were specified on
the
SQLBindCol(), SQLGetData() and
SQLBindParameter() ODBC calls used
internally by mxODBC. This length does not
include any null-terminator. For exact numeric
data types, the length accounts for the decimal
and the sign.
Note: This column is of little value to Python
applications.
DECIMAL_DIGITS SMALLINT The scale of the column. NULL is returned for
129