RESOURCETYPE

CHAR(4)

Resource type keyword:

• 'DACC'—Access module
• 'QSCH'—SQL Schema
• 'TABL'—Table

RESOURCENAME

CHAR(60)

The resource name; for a table or access module, the name is fully qualified with schema-name.

GROUPTYPE

CHAR(4)

The resource group to which the resource belongs:

• 'QSCH'—SQL schema
• Null when RESOURCETYPE is 'QSCH'

GROUPNAME

CHAR(60)

The name of the resource group (SQL Schema) to which the resource belongs; null when RESOURCETYPE is 'QSCH'

NUMBER

SMALLINT

(Not applicable—initialized to zero.)

AMRUNNABLE

CHAR(1)

(Reserved—initialized to 'N'.)

STATUS

CHAR(1)

(Reserved—initialized to 'A'.)

AMGRANTABLE

CHAR(1)

(Reserved—initialized to 'N'.)

AMLASTCHANGE

TIMESTAMP

(Reserved—initialized to binary zeros.)

CTIME

TIMESTAMP

Time created.

UTIME

TIMESTAMP

Time of the last update.

CUSER

CHAR(18)

ID of the user who created the resource.

UUSER

CHAR(18)

ID of the user who last updated the resource.

FILLER

BINARY(21)

(Reserved—initialized to spaces.)