DB2 graphic  QMF Version 8

Reading the Q.OBJECT_REMARKS table

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:

Table 34. Structure of the Q.OBJECT__REMARKS table
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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004