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.
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:
|
||
1213 | -- Column name, expression, or summary function
short length (255) expanded length (560) |
||
T | 1310 | - | Row selection conditions |
1312 | -- Entry type:
|
||
1313 | -- For entry type '1',
identifies column type:
|
||
-- For entry type '2',
identifies the verb:
|
|||
-- For entry type '3', (not used) | |||
-- For entry type '4',
identifies a connector:
|
|||
1314 | -- For entry type '1' this
field is:
expanded length (560) |
||
-- For entry type '2',
identifies the operator:
|
|||
-- For entry type '3', identifies a value | |||
-- For entry type '4', (not used) | |||
T | 1410 | - | Sort conditions table |
1412 | -- Sort direction:
|
||
1413 | -- Column
short length (255) expanded length (560) |
||
V | 1501 | Duplicate rows treatment:
|
The meaning of values for fields 1313 and 1314 depends on the sequence number indicated in field number 1312 in the 1310 table.