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.

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 ]