DB2 graphic QMF Version 8

Table and field numbers for the prompted query object

The following table contains prompted query table and field numbers for T records that describe each table in the prompted query exported format. The information in the DESCRIPTION column uniquely identifies specific fields in the prompted query base panel.

Table definitions (field number 1110) are always exported. Join conditions (field number 1510) are always exported if more than one table is selected.

To import a prompted query file, the file must have a H record followed by the tables T record. No tables need to be specified. If no tables are specified, an empty query is imported. Join conditions are not required unless more than one table is selected.

Table 24. Table and field numbers for exported prompted query object
Record type Table number Field number Field description
T 1110 - Table definitions table
1112 -- Table ID (valid table IDs are A-Z, and #,$,@)
1113 -- Table name
short length (50)
expanded length (280)
       
T 1150 - Join conditions table
1152 -- Column 1 name
short length (22)
expanded lentth (34)
1153 -- Column 2 name
short length (22)
expanded lentth (34)
     
T 1210 - Columns table
1212 -- Column type:
  • C=column
  • E=expression
  • S=summary function with expression
  • F=summary function with only a column
1213 -- Column name, expression, or summary function
short length (255)
expanded length (560)
       
T 1310 - Row selection conditions
1312 -- Entry type:
  • 1 - left of operator
  • 2 - operator
  • 3 - right of operator
  • 4 - connector
1313 -- For entry type '1', identifies column type:
  • C=column
  • E=expression
  • S=summary function
  • F=summary function (column name only specified)
-- For entry type '2', identifies the verb:
  • IS for 'is' (Default)
  • ISN for 'is not'
-- For entry type '3', (not used)
-- For entry type '4', identifies a connector:
  • O for 'or'
  • A for 'and' (Default)
1314 -- For entry type '1' this field is:
  • Column name, expression, or summary function
short length (255)
expanded length (560)
-- For entry type '2', identifies the operator:
  • EQ for 'equal to'
  • LT for 'less than'
  • LE for 'less than or equal to'
  • GT for 'greater than'
  • GE for 'greater than or equal to'
  • BT for 'between'
  • SW for 'starting with'
  • EW for 'ending with'
  • CT for 'containing'
  • NL for NULL
-- For entry type '3', identifies a value
-- For entry type '4', (not used)
       
T 1410 - Sort conditions table
1412 -- Sort direction:
  • A for 'ascending'
  • D for 'descending'
1413 -- Column
short length (255)
expanded length (560)
       
V 1501 Duplicate rows treatment:
  • K for 'keep'
  • D for 'discard'

The meaning of values for fields 1313 and 1314 depends on the sequence number indicated in field number 1312 in the 1310 table.


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