NAME

Schema name.

CHAR(18)

NOT NULL

CTIME

Date and time when the schema was created.

TIMESTAMP

NOT NULL

UTIME

Date and time when the schema was last altered.

TIMESTAMP

NOT NULL

CUSER

ID of the user who created the schema.

CHAR(18)

NOT NULL

UUSER

The ID of the user who last altered the schema.

CHAR(18)

NOT NULL

TYPE

Type of schema:

• N—Represents non-SQL schema
• R—SQL schema

CHAR(1)

NOT NULL

SEGMENT

• When TYPE is N, the segment(specified in CREATE SCHEMA) that contains the data described by the non-SQL schema.

If this column is blank and TYPE is N, a segment is chosen from the database name table at runtime.

• When TYPE is R, the segment that contains the default area.

If this column and the AREA column are blank and TYPE is R, the storage area for a table associated with this schema is identified in SYSTEM.TABLE.

CHAR(8)

NOT NULL

AREA

When TYPE is R, the default area for storing rows of tables associated with the schema.

CHAR(18)

NOT NULL

NODE

If it was specified when the SQL schema was created, node name of the dictionary that contains the non-SQL-defined schema (when TYPE is N).

CHAR(8)

NOT NULL

DICTIONARY

If it was specified when the SQL schema was created, name of the dictionary that contains the non-SQL-defined schema (when TYPE is N).

CHAR(8)

NOT NULL

NTWKSCHEMA

Name of the non-SQL schema.

CHAR(8)

NOT NULL

VERSION

Version number of the non-SQL schema.

SMALLINT

NOT NULL

CHARSET

Default character set for all columns in the catalog.

CHAR(18)

NOT NULL

REFDSQLSCHEMA

Name of referenced SQL schema.

CHAR(18)

NOT NULL

FILLER

Reserved for future use.

BINARY(4)

NOT NULL