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:

Table 1. Structure of the Q.OBJECT_DIRECTORY table
Column name	Data type and length	Nulls allowed?	Function/values
OWNER	VARCHAR(128) 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.
NAME	VARCHAR(128) 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, or FOLDER. Exception: DB2 Server for VSE and VM.
SUBTYPE	CHAR(8)	Yes	The following subtypes are used for QUERY objects: SQL QBE PROMPTED The following subtypes are used for ANALYTIC objects: PLOT Plot chart HIST Histogram PIE Pie chart TOWER Tower chart MIXED Mixed chart MAP Map UNIVAR Univariate curve LINEAR Linear trend DCF Discounted clash flow BASIC Basic statistics BIVAR Bivariate curve WILCOSR Wilcoxon Signed-Rank Test MANNW Mann-Whitney U Test 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: CONVERT DISPLAY EXPORT IMPORT LAYOUT PRINT RUN SAVE 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.