IBM Books

Administration Guide


SYSCAT.DATATYPES

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

Table 74. 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. Always 0.
REMARKS VARCHAR(254) Yes User-supplied comment, or null.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]