This table contains one row for each query, form, and procedure in the database. The row contains comments entered using the QMF SAVE command when the object was created or last replaced. (See the description of the SAVE command in DB2 QMF Reference.)
The Q.OBJECT__REMARKS table has the index Q.OBJECT_REMARKSX, with the attributes UNIQUE and CLUSTER. Keyed columns are OWNER and NAME.
The table has the structure shown in Table 34:
Column name | Data type | Length (bytes) | Nulls allowed? | Function/values |
---|---|---|---|---|
OWNER | CHAR | Determined by database | No | Shows the authorization ID of the user who created the object |
NAME | VARCHAR | Determined by database | No | Shows the name of the object. |
TYPE | CHAR | 8 | No | Shows the type of the object: FORM, PROC, or QUERY. |
REMARKS | VARCHAR | Determined by database | Yes | Contains the comment that was saved with the object when it was created or replaced. |