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.
|
| 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 1200Nullable ![]() |
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
1200Nullable ![]() |
A character string supplied with
the LABEL statement (type text).Contains the null value if the type has no text. ![]() |
MAXIMUM_CARDINALITY![]() |
MAXCARD![]() |
BIGINTNullable ![]() |
The maximum cardinality of the array data type.Contains the null value if the type is not an array type. ![]() |