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 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 56:

Table 56. Structure of the Q.OBJECT__REMARKS table
Column name Data type Length (bytes) Nulls allowed? Function/values
OWNER CHAR 8 No Shows the authorization ID of the user who created the object
NAME VARCHAR 18 No Shows the name of the object.
TYPE CHAR 8 No Shows the type of the object: FORM, PROC, or QUERY.
REMARKS VARCHAR 254 Yes Contains the comment that was saved with the object when it was created or replaced.
[ Previous Page | Next Page | Contents | Index ]