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 built-in data
type:
|
| 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 Nullable |
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 IBM® i CLI data type of the data type.
|