Exporting a form

 SELECT JOB
 FROM Q.STAFF
 WHERE NAME='NO_NAME'

H QMF 20 F 04 E V W E R 01 03 13/01/15 16:20

• Record identifier for all records
• The following fields in the header record:
  • Product identifier (QMF)
  • Type of object (F)
  • Format of object (E)
  • Action against object (R)
• Data type values (numeric, character, graphic, or unknown data types) in the R records for the COLUMNS table

  If your site supports date/time data types, data type values DATE, TIME, TIMEST, and TSTMPTZ must also be in uppercase.

• All the form keywords and substitution variables used in the form panels

  When a form is imported, all the input in the form is left intact. If a form keyword is in lowercase, the error indicator in the form panel is turned on. To correct the error, the field must be typed over. If the data-type value is not in uppercase, an error occurs, and the IMPORT ends.

• Variation panels

  The variation number field (field number 2790) determines which variation panel is updated by all the variation panel information that follows the field. This V record should precede all other V, T, and R records for a variation panel.

  If a value for a particular variation appears more than once in the encoded format, the later values replace the original values. The number of variations in the form are equal to the highest variation number in the form. There is no required order for variation numbers when importing.

• Translated forms

  When you import an English-language form into a non-English session and the national language identifier in the H record is an E, QMF translates the reserved words. QMF translates the reserved words into your current session's language. Examples of reserved words are values in the USAGE column in FORM.COLUMNS

• Omitting data type, edit code, and width in an imported form
  In the COLUMNS table, data type (field number 1112), edit code (field number 1117), and width (field number 1116) can optionally be omitted when the following rules are observed:

  • Edit code must be included if data type and width are omitted. Based on the specified edit code, QMF inserts appropriate defaults for data type and width.
  • Data type must be included if edit code and width are omitted. QMF provides default values for edit code and width.
  • Width must be accompanied by either data type or edit code.

  This table contains information about values for the field that contains the data type of the column. In addition to the data type values shown here, there is an UNKNOWN data type keyword that QMF uses in response to a U, V, or invalid edit code.

  Table 4. Values for the field that contains the data type of the column

  Data type as it appears in externalized form	Code in decimal	Data type	Meaning
  DATE	384	DATE	Date
  TIME	388	TIME	Time
  TIMEST	392	TIMESTAMP	Timestamp
  NUMERIC	496 500 492 484 480 996	INTEGER SMALLINT BIGINT DECIMAL FLOAT DECFLOAT	Integer Small integer Big integer Decimal Floating point Decimal floating point
  CHAR	448 452 456 904	VARCHAR CHAR LONG VARCHAR ROWID	Varying-length character Fixed-length character Long varying-length character Row identifier
  GRAPHIC	464 468 472	VARGRAPHIC GRAPHIC LONG VARGRAPHIC	Varying-length graphic Fixed-length graphic Long varying-length graphic
  BINARY	908 912	VARBINARY BINARY	Varying-length binary Fixed-length binary
  TSTMPTZ	2448	TIMESTAMP WITH TIME ZONE	Timestamp with time zone

• Detecting errors during import

  If QMF detects an error in the format of the form file during import, the import function ends. QMF issues a message describing the error and its location in the file.

  If an error is encountered in the header record and a form exists in the temporary storage area, the existing form is displayed. If the form is successfully imported, QMF displays the form panel.

  If an error is encountered after the header record is read, any existing form in the temporary storage area is discarded, and the home panel is displayed. However, if the data object exists, QMF generates a default form for the data but does not display it.

  Certain minor errors detected by QMF do not terminate the import. In such cases, QMF issues a warning message and, where appropriate, applies defaults. Some examples are:

  • V records
    • Zero-length fields
    • The specified length field does not match the length of the data supplied.
  • T records
    • Zero column length
    • The number of columns specified does not match the following field number/length pairs.

  You can respond to errors and warnings as follows:

  • Fix one problem at a time.
  • Set the TRACE option of the profile to L2 (by using the command SET PROFILE (TRACE=L2) and run the IMPORT FORM command. The L2 tracing option traces messages and commands at the highest level of detail. This option allows you to see all the message text related to the IMPORT command.
  The following command displays the message text associated with a particular message code:

  HELP DSQnnnnn

  where nnnnn is a 5-character, unique message code.