DB2 graphic  QMF Version 8

Reading the Q.OBJECT__DATA table

This table contains one or more rows for each query, form, and procedure in the database. Each row contains all or part of the defining text for one of these objects. Objects are reconstructed from this text by combining the text with the corresponding format number in the OBJECTLEVEL column of the Q.OBJECT__DIRECTORY table.

The Q.OBJECT__DATA table has the index Q.OBJECT__OBJDATAX, with attributes UNIQUE and CLUSTER. Keyed columns are OWNER, NAME, and SEQ.

The table has the structure shown in Table 33:

Table 33. Structure of the Q.OBJECT__DATA table
Column name Data type Length (bytes) Nulls allowed? Function/values
OWNER VARCHAR Determined by database No Shows the authorization ID of the creator of the object.
NAME VARCHAR Determined by database No Shows the name of the object.
TYPE CHAR 8 No Shows the type of object: FORM, PROC, or QUERY.
SEQ SMALLINT 2 No Indicates the sequence that this text occupies within the entire text of the object. For example, if this row is the first row of text in the object, SEQ is 1; if it is the second, SEQ is 2, and so on.
APPLDATA LONG VARCHAR FOR BIT DATA (see note) Determined by database Yes Contains all or part of text that defines the object. Text appears in an internal QMF format. The OBJECTLEVEL column in Q.OBJECT__DIRECTORY defines this format.
Attention: The APPLDATA column must never be subjected to code page (CCSID) conversion.


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