Installation guide

7. mxODBC Cursor Objects
Column Name Column Datatype Comment
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.
NUM_PREC_RADIX SMALLINT Either 10 or 2 or NULL. If DATA_TYPE is an
approximate numeric data type, this
column contains the value 2, then the
COLUMN_SIZE column contains the
number of bits allowed in the column.
If DATA_TYPE is an exact numeric data
type, this column contains the value 10 and
the COLUMN_SIZE contains the number of
decimal digits allowed for the column.
For numeric data types, the database can
return a NUM_PREC_RADIX of either 10 or
2.
INTERVAL_PRECISION SMALLINT Datetime interval precision or NULL is
interval types are not supported by the
database.
.primarykeys(qualifier=None, owner=None, table=None)
Query the data source for information on the primary keys of a given table.
The
table parameter is mandatory.
The method is useful when inspecting unknown database schemas. It only
supports returning the primary key column(s) for a single table.
The catalog method generates a result set having the following schema:
Column Name Column Datatype Comment
TABLE_CAT VARCHAR(128) Always NULL.
TABLE_SCHEMA VARCHAR(128) The name of the schema containing
TABLE_NAME.
TABLE_NAME VARCHAR(128) not
NULL
The name of the table, or view, or alias, or
synonym.
COLUMN_NAME VARCHAR(128) not Primary Key column name.
123