SYSTYPES
The SYSTYPES table contains one row for each built-in data type and each distinct type and array type created by the CREATE TYPE statement.
The following table describes the columns in the SYSTYPES table:
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
USER_DEFINED_TYPE_SCHEMA | TYPESCHEMA | VARCHAR(128) | Schema name of the data type. |
USER_DEFINED_TYPE_NAME | TYPENAME | VARCHAR(128) | Name of the data type. |
USER_DEFINED_TYPE_DEFINER | DEFINER | VARCHAR(128) | Name of the user that created the data type. |
SOURCE_SCHEMA | SRCSCHEMA | VARCHAR(128) Nullable
|
The schema for the source data type
of this data type. Contains the null value if this is a built-in data type. |
SOURCE_TYPE | SRCTYPE | VARCHAR(128) Nullable
|
Name of the source data type of this
data type. Contains the null value if this is a built-in data type. |
SYSTEM_TYPE_SCHEMA | SYSTSCHEMA | CHAR(10) | System schema name of the data type. |
SYSTEM_TYPE_NAME | SYSTNAME | CHAR(10) | System name of the data type. |
METATYPE | METATYPE | CHAR(1) | Indicates the type of data type.
|
LENGTH | LENGTH | INTEGER | The length attribute of
the data type; or, in the case of a decimal, numeric, or nonzero precision
binary column, its precision. For an array data type, it is the length
of a single array element:
|
NUMERIC_SCALE | SCALE | SMALLINT Nullable
|
Scale of numeric data. Contains the null value if the data type is not decimal, numeric, or binary. |
CCSID | CCSID | INTEGER Nullable
|
The CCSID value for CHAR,
VARCHAR, CLOB, DATE, TIME, TIMESTAMP, GRAPHIC, VARGRAPHIC, DBCLOB,
XML, and DATALINK data types. Contains the null value if the data type is numeric. |
STORAGE | STORAGE | INTEGER | The storage requirements for the
data type:
Note: This column supplies the storage requirements
for all data types.
|
NUMERIC_PRECISION | PRECISION | INTEGER Nullable
|
The precision of all numeric data
types. Note: This column supplies the precision of all numeric data
types, including decimal floating-point and single-and double-precision
floating point. The NUMERIC_PRECISION_RADIX column indicates if the
value in this column is in binary or decimal digits.
Contains the null value if the data type is not numeric. |
CHARACTER_MAXIMUM_LENGTH | CHARLEN | INTEGER Nullable
|
Maximum length of the
string for binary, character, and graphic string and XML data types.
Contains the null value if the data type is not a string. |
CHARACTER_OCTET_LENGTH | CHARBYTE | INTEGER Nullable
|
Number of bytes for binary,
character, and graphic string and XML data types. Contains the null value if the data type is not a string. |
ALLOCATE | ALLOCATE | INTEGER Nullable
|
Allocated length of the string for
binary, varying-length character, varying-length graphic, and XML
data types. Contains the null value if the data type is numeric or fixed-length, or an array data type. |
NUMERIC_PRECISION_RADIX | 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 data type is not numeric. |
DATETIME_PRECISION | DATPRC | INTEGER Nullable
|
The fractional part of a date, time,
or timestamp.
Contains the null value if the data type is not date, time, or timestamp. |
CREATE_TIME | CRTTIME | TIMESTAMP Nullable
|
Identifies the timestamp when the data type was created. |
LONG_COMMENT | REMARKS | VARGRAPHIC(2000) CCSID 1200 Nullable
|
A character string supplied with
the COMMENT statement. Contains the null value if there is no long comment. |
IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number of the data type. |
LAST_ ALTERED | ALTEREDTS | TIMESTAMP Nullable
|
Reserved. Contains the null value. |
NORMALIZE_DATA | NORMALIZE | VARCHAR(3) Nullable
|
Indicates whether the parameter value
should be normalized or not. This attribute only applies to UTF-8
and UTF–16 data.
|
TYPE_TEXT | LABEL | VARGRAPHIC(50) CCSID
1200 Nullable
|
A character string supplied with
the LABEL statement (type text). Contains the null value if the type has no text. |
MAXIMUM_CARDINALITY | MAXCARD | BIGINT Nullable
|
The maximum cardinality of the array data type. Contains the null value if the type is not an array type. |