Importing a prompted query

If you want to import a prompted query object that your application edited or generated, be aware of the following:

• When a prompted query file is imported, the incoming records must be in a specific order following the header (H) record. The order should be:
  1. T records for table definitions
  2. R records for table names
  3. T records for column definitions
  4. R records for columns
  5. Row condition records (field number 1310) must be in order within each condition according to the entry type sequence number (field number 1312), that is, the same order that row data appears in the Prompted Query echo area.
  6. The remaining records can be in any order.
• The Tables table must appear before any other tables or V records.
• The value of row count in the Tables T record must be * or an integer from 0 through 15. A zero value in the row count causes everything in the query to be ignored, which means that an empty query is imported.
• QMF does not issue warnings for Prompted Query imports.
• If a second Tables table (table 1110) is specified, QMF issues an error, and the contents of the table are ignored.
• Prompted Query does not supply default values on import.
• If there is a Sort table, there must be a Columns table preceding it.
• QMF accepts duplicate records in the import file. The most recent value for the record is used.
• All column names must be qualified by the table identifier during import.
• When a prompted query is exported to a preallocated data set, the minimum logical record length (LRECL) allowed is 259 bytes.
• The exported format of a prompted query is the same regardless of the national language used; the format is language independent. The language byte in the header record is ignored during import. You can see the codes used in exporting a prompted query in Table and field numbers for the prompted query object.

  Summary functions and expressions are not translated; thus summary functions COUNT, AVG, SUM, MIN, and MAX remain unchanged. They are SQL symbols, which are not translated.