Structure of the Q.OBJECT_DIRECTORY table
The Q.OBJECT_DIRECTORY table contains a row for each QMF query, form, procedure, folder, and analytics objects in the database.
The table has the index Q.OBJECT_DIRECTORYX, with the UNIQUE and CLUSTER attributes. The keyed columns are OWNER and NAME.
The Q.OBJECT_DIRECTORY table has the structure shown in the following table:
|Column name||Data type and length||Nulls allowed?||Function/values|
Exception: The OWNER column is defined as CHAR(8) when you are connected to a DB2® for VSE and VM database.
|No||Shows the authorization ID of the creator of the object.|
Exception: The NAME column is defined as VARCHAR(18) when you are connected to a DB2 for VSE and VM database.
|No||Shows the name of the object.|
|TYPE||CHAR(8)||No||Shows the type of object: FORM, PROC, ANALYTIC, QUERY,
Exception: DB2 Server for VSE and VM.
|SUBTYPE||CHAR(8)||Yes||The following subtypes
are used for QUERY objects:
This field is blank for all other object types.
|OBJECTLEVEL||INTEGER(4)||No||QMF uses this number to reconstruct an object from its defining text in the Q.OBJECT_DATA table.|
|RESTRICTED||CHAR(1)||No||YES if the object has not been shared (using the SHARE parameter of the QMF SAVE command or the SHARE option of the SAVE panel in QMF Analytics for TSO); NO if the object has been shared with other users.|
|MODEL||CHAR(8)||Yes||This value is always REL, indicating relational data.|
|CREATED||TIMESTAMP||Yes||Shows the timestamp value for when an object was created. The value is recorded after SAVE or IMPORT commands.|
|MODIFIED||TIMESTAMP||Yes||Shows the timestamp value for when an object was last modified. The value is recorded after SAVE or IMPORT commands.|
|LAST_USED||TIMESTAMP||Yes||Shows the date value for when an object was last used,
regardless of whether the command that accessed the object was successful.
However, in some cases, the LAST_USED column is not updated immediately
after a command is issued, and if QMF is
terminated abnormally, the column might not be updated.
By default, the following commands cause the LAST_USED value to change:
You can restrict the LAST_USED column to updates by RUN, SAVE, and IMPORT commands only by setting the DSQEC_LAST_RUN global variable to 1.
You can also restrict the LAST_USED column to updates by the RUN command only by setting the DSQEC_LAST_RUN global variable to 2.
The value is updated only once a day, even if the object is used multiple times.