SQL Reference

SYSCAT.ATTRIBUTES

Contains one row for each attribute (including inherited attributes where applicable) that is defined for a user-defined structured data type.

Table 42. SYSCAT.ATTRIBUTES Catalog View

Column Name Data Type Nullable Description
TYPESCHEMA VARCHAR(128)
Qualified name of the strucutred data type that includes the attribute.
TYPENAME VARCHAR(18)
ATTR_NAME VARCHAR(18)
Attribute name.
ATTR_TYPESCHEMA VARCHAR(128)
Contains the qualified name of the type of the attribute.
ATTR_TYPENAME VARCHAR(18)
TARGET_TYPESCHEMA VARCHAR(128)
Qualified name of the target type, if the type of the attribute is REFERENCE. Null value if the type of the attribute is not REFERENCE.
TARGET_TYPENAME VARCHAR(18)
SOURCE_TYPESCHEMA VARCHAR(128)
Qualified name of the data type in the data type hierarchy where the attribute was introduced. For non-inherited attributes, these columns are the same as TYPESCHEMA and TYPENAME.
SOURCE_TYPENAME VARCHAR(18)
ORDINAL SMALLINT
Position of the attribute in the definition of the structured data type starting with zero.
LENGTH INTEGER
Maximum length of data. 0 for distinct types. The LENGTH column indicates precision for DECIMAL fields.
SCALE SMALLINT
Scale for DECIMAL fields; 0 if not DECIMAL.
CODEPAGE SMALLINT
Code page of the attribute. For character-string attributes not defined with FOR BIT DATA, the value is the database code page. For graphic-string attributes, the value is the DBCS code page implied by the (composite) database code page. Otherwise, the value is 0.
LOGGED CHAR(1)
Applies only to attributes whose type is LOB or distinct based on LOB (blank otherwise).

Y = Attribute is logged.
N = Attribute is not logged.

COMPACT CHAR(1)
Applies only to attributes whose type is LOB or distinct based on LOB (blank otherwise).

Y = Attribute is compacted in storage.
N = Attribute is not compacted.

DL_FEATURES CHAR(10)
Applies to DATALINK type attributes only. Blank for REFERENCE type attributes. Null otherwise. Encodes various DATALINK features such as linktype, control mode, recovery, and unlink properties.

Column Name	Data Type	Description
TYPESCHEMA	VARCHAR(128)	Qualified name of the strucutred data type that includes the attribute.
TYPENAME	VARCHAR(18)
ATTR_NAME	VARCHAR(18)	Attribute name.
ATTR_TYPESCHEMA	VARCHAR(128)	Contains the qualified name of the type of the attribute.
ATTR_TYPENAME	VARCHAR(18)
TARGET_TYPESCHEMA	VARCHAR(128)	Qualified name of the target type, if the type of the attribute is REFERENCE. Null value if the type of the attribute is not REFERENCE.
TARGET_TYPENAME	VARCHAR(18)
SOURCE_TYPESCHEMA	VARCHAR(128)	Qualified name of the data type in the data type hierarchy where the attribute was introduced. For non-inherited attributes, these columns are the same as TYPESCHEMA and TYPENAME.
SOURCE_TYPENAME	VARCHAR(18)
ORDINAL	SMALLINT	Position of the attribute in the definition of the structured data type starting with zero.
LENGTH	INTEGER	Maximum length of data. 0 for distinct types. The LENGTH column indicates precision for DECIMAL fields.
SCALE	SMALLINT	Scale for DECIMAL fields; 0 if not DECIMAL.
CODEPAGE	SMALLINT	Code page of the attribute. For character-string attributes not defined with FOR BIT DATA, the value is the database code page. For graphic-string attributes, the value is the DBCS code page implied by the (composite) database code page. Otherwise, the value is 0.
LOGGED	CHAR(1)	Applies only to attributes whose type is LOB or distinct based on LOB (blank otherwise). Y = Attribute is logged. N = Attribute is not logged.
COMPACT	CHAR(1)	Applies only to attributes whose type is LOB or distinct based on LOB (blank otherwise). Y = Attribute is compacted in storage. N = Attribute is not compacted.
DL_FEATURES	CHAR(10)	Applies to DATALINK type attributes only. Blank for REFERENCE type attributes. Null otherwise. Encodes various DATALINK features such as linktype, control mode, recovery, and unlink properties.

[ Top of Page | Previous Page | Next Page ]