The SQLTYPEINFO view contains one row for every built-in data type.
The following table describes the columns in the view:
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 | 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 | Indicates whether the data type is nullable.
|
CASE_SENSITIVE | SMALLINT | Indicates whether the data type is case sensitive.
|
SEARCHABLE | SMALLINT | 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 | 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 CLI data type of the column.
|
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.