The SQLTYPEINFO table contains one row for every built-in data type. The following table describes the columns in the table:
Column Name | Data Type | Description |
---|---|---|
TYPE_NAME | VARCHAR(128) | Name of the built-in data type:
|
DATA_TYPE | SMALLINT | The data type of the column:
|
COLUMN_SIZE | INTEGER
Nullable |
The maximum length of the data type. |
LITERAL_PREFIX | VARCHAR(128)
Nullable |
Indicates the prefix for a string literal.
Contains the null value if the data type is not a string. |
LITERAL_SUFFIX | VARCHAR(128)
Nullable |
Indicates the suffix for a string literal.
Contains the null value if the data type is not a string. |
CREATE_PARAMS | VARCHAR(128)
Nullable |
Indicates the parameters supported with the
data type.
Contains the null value for all other data types. |
NULLABLE | SMALLINT
Nullable |
Indicates whether the data type is nullable.
|
CASE_SENSITIVE | SMALLINT
Nullable |
Indicates whether the data type is case sensitive.
|
SEARCHABLE | SMALLINT
Nullable |
Indicates whether the data type can be used
in a predicate.
|
UNSIGNED_ATTRIBUTE | SMALLINT
Nullable |
Indicates whether the numeric data type is
signed or unsigned.
Contains the null value if the data type is not numeric. |
FIXED_PREC_SCALE | SMALLINT | Indicates whether the data type has a fixed
precision and scale.
|
AUTO_UNIQUE_VALUE | SMALLINT
Nullable |
Indicates whether the numeric data type is
auto-incrementing:
Contains the null value if the data type is not numeric. |
LOCAL_TYPE_NAME | VARCHAR(128)
Nullable |
Reserved. Contains the null value. |
MINIMUM_SCALE | SMALLINT
Nullable |
Indicates the minimum scale of numeric data
types.
Contains the null value if the data type is not numeric. |
MAXIMUM_SCALE | SMALLINT
Nullable |
Indicates the maximum scale of numeric data
types.
Contains the null value if the data type is not numeric. |
SQL_DATA_TYPE | SMALLINT
Nullable |
Indicates the SQL data type value of the
data type:
|
SQL_DATETIME_SUB | SMALLINT
Nullable |
The datetime subtype of the data type:
Contains the null value if the data type is not a datetime data type. |
NUM_PREC_RADIX | INTEGER
Nullable |
Indicates if the precision specified in column
NUMERIC_PRECISION is specified as a number of binary or decimal digits:
Contains the null value if the parameter is not numeric. |
INTERVAL_PRECISION | SMALLINT
Nullable |
Reserved. Contains the null value. |
JDBC_DATA_TYPE | SMALLINT | The JDBC data type value of the data type:
|
I_DATA_TYPE | SMALLINT | Indicates the iSeries(TM) CLI data type of the column.
|
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.