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:

Table 1. 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. A Array data type S System predefined data type. T User-defined distinct 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: 8 bytes BIGINT 4 bytes INTEGER 2 bytes SMALLINT Precision of number DECIMAL Precision of number NUMERIC 8 bytes FLOAT, FLOAT(n) where n = 25 to 53, or DOUBLE PRECISION 4 bytes FLOAT(n) where n = 1 to 24, or REAL 8 bytes DECFLOAT(16) 16 bytes DECFLOAT(34) Length of string CHARACTER Maximum length of string VARCHAR or CLOB Length of graphic string GRAPHIC Maximum length of graphic string VARGRAPHIC or DBCLOB Length of binary string BINARY Maximum length of binary string VARBINARY or BLOB 4 bytes DATE 3 bytes TIME The integral part of ((p+1)/2)+7 where p is the precision of the timestamp TIMESTAMP Maximum length of datalink URL and comment DATALINK 40 bytes ROWID 2147483647 bytes XML Same value as the source type DISTINCT
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: 8 bytes BIGINT 4 bytes INTEGER 2 bytes SMALLINT (Precision/2) + 1 DECIMAL Precision of number NUMERIC 8 bytes FLOAT, FLOAT(n) where n = 25 to 53, or DOUBLE PRECISION 4 bytes FLOAT(n) where n = 1 to 24, or REAL 8 bytes DECFLOAT(16) 16 bytes DECFLOAT(34) Length of string CHAR Maximum length of string + 2 VARCHAR Maximum length of string + 29 CLOB Length of string * 2 GRAPHIC Maximum length of string * 2 + 2 VARGRAPHIC Maximum length of string * 2 + 29 DBCLOB Length of binary string BINARY Maximum length of binary string + 2 VARBINARY Maximum length of string + 29 BLOB 4 bytes DATE 3 bytes TIME The integral part of ((p+1)/2)+7 where p is the precision of the timestamp TIMESTAMP Maximum length of datalink URL and comment + 24 DATALINK 42 bytes ROWID 2147483647 bytes + 29 XML Same value as the source type DISTINCT 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: 2 Binary; floating-point precision is specified in binary digits. 10 Decimal; all other numeric types are specified in 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. 0 For DATE and TIME data types 0-12 For TIMESTAMP data types (number of fractional seconds). 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. NO The value should not be normalized. YES The value should be normalized.
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.