SAP DB:ODBC Przewodnik Instalacji Pobierz pdf (Strona 145)

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

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

1 2 ... 140 141 142 143 144 145 146 147 148 149 150 ... 224 225

Brak uwag

SAP DB:ODBC Przewodnik Instalacji Strona 145