Installation guide

7. mxODBC Cursor Objects
Column Name Column Datatype Comment
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.
LITERAL_PREFIX VARCHAR(128) Prefix for a literal of this data type. This
column is NULL for data types where a
literal prefix is not applicable.
LITERAL_SUFFIX VARCHAR(128) Suffix for a literal of this data type. This
column is NULL for data types where a
literal prefix is not applicable.
CREATE_PARAMS VARCHAR(128) The text of this column contains a list of
keywords, separated by commas,
corresponding to each parameter the
application may specify in parenthesis when
using the name in the TYPE_NAME column
as a data type in SQL.
The keywords in the list can be any of the
following: "LENGTH", "PRECISION",
"SCALE". They appear in the order that the
SQL syntax requires that they be used.
NULL is returned if there are no parameters
for the data type definition, (such as
INTEGER).
Note: The intent of CREATE_PARAMS is to
enable an application to customize the
interface for a DDL builder.
NULLABLE SMALLINT not NULL Indicates whether the data type accepts a
NULL value
SQL.NO_NULLS - NULL values are
disallowed.
SQL.NULLABLE - NULL values are allowed.
CASE_SENSITIVE SMALLINT not NULL Indicates whether the data type can be
treated as case sensitive for collation
purposes; valid values are SQL.TRUE and
SQL.FALSE.
SEARCHABLE SMALLINT not NULL Indicates how the data type is used in a
WHERE clause. Valid values are:
SQL.UNSEARCHABLE: if the data type
cannot be used in a WHERE clause.
121