SQL Reference

SYSCAT.DATATYPES

Contains a row for every data type, including built-in and user-defined types.

Table 53. SYSCAT.DATATYPES Catalog View
Column Name Data Type Nullable Description
TYPESCHEMA VARCHAR(128)
Qualified name of the data type (for built-in types, TYPESCHEMA is SYSIBM).
TYPENAME VARCHAR(18)
DEFINER VARCHAR(128)
Authorization ID under which type was created.
SOURCESCHEMA VARCHAR(128) Yes Qualified name of the source type for distinct types. Qualified name of the builtin type used as the reference type that is used as the representation for references to structured types. Null for other types.
SOURCENAME VARCHAR(18) Yes
METATYPE CHAR(1)

S = System predefined type

T = Distinct type

R = Structured type


TYPEID SMALLINT
The system generated internal identifier of the data type.
SOURCETYPEID SMALLINT Yes Internal type ID of source type (null for built-in types). For user-defined structured types, this is the internal type ID of the reference representation type.
LENGTH INTEGER
Maximum length of the type. 0 for system predefined parameterized types (for example, DECIMAL and VARCHAR). For user-defined structured types, this indicates the length of the reference representation type.
SCALE SMALLINT
Scale for distinct types or reference representation types based on the system predefined DECIMAL type. 0 for all other types (including DECIMAL itself). For user-defined structured types, this indicates the length of the reference representation type.
CODEPAGE SMALLINT
Code page for character and graphic distinct types or reference representation types; 0 otherwise.
CREATE_TIME TIMESTAMP
Creation time of the data type.
ATTRCOUNT SMALLINT
Number of attributes in data type.
INSTANTIABLE CHAR(1)

Y = Type can be instantiated.

N = Type can not be instantiated.


WITH_FUNC_ACCESS CHAR(1)

Y = All the methods for this type can be invoked using function notation.

N = Methods for this type can not be invoked using function notation.


FINAL CHAR(1)

Y = User-defined type can not have subtypes.

N = User-defined type can have subtypes.


INLINE_LENGTH INTEGER
Length of structured type that can be kept with base table row. 0 if no value explicitly set by CREATE TYPE statement.
REMARKS VARCHAR(254) Yes User-supplied comment, or null.


[ Top of Page | Previous Page | Next Page ]