This table contains a row for each QMF query, form, and procedure in the database. The table has the index Q.OBJECT__DIRECTORYX, with attributes UNIQUE and CLUSTER. The keyed columns are OWNER and NAME. No two rows can have identical values for these columns.
The Q.OBJECT__DIRECTORY table has the structure shown in Table 54:
| Column name | Data type | Length (bytes) | Nulls allowed? | Function/values |
|---|---|---|---|---|
| OWNER | CHAR | 8 | No | Shows the authorization ID of the creator of the object. |
| NAME | VARCHAR | 18 | No | Shows the name of the object. |
| TYPE | CHAR | 8 | No | Shows the type of object: FORM, PROC, or QUERY. |
| SUBTYPE | CHAR | 8 | Yes | Shows SQL, QBE, or PROMPTED when TYPE is QUERY. Null or blank if TYPE is not QUERY. |
| 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); 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. The value is updated only once a day. |