SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
I-26
INVOKE Directive and Command
If you omit the AS clause, the record name depends on the FORMAT option. For
COBOL85, the record name is the unqualified name of the table or view. (For
example, if the table name is \SYS1.$VOL1.PERSNL.JOB, the record name is
JOB.) For C or PASCAL, the record name is the unqualified name of the table or
view with the suffix “_type” appended. (For example, JOB_TYPE.) For TAL, the
record name is the unqualified name of the table or view with the suffix “^type”
appended and an asterisk indicating a structure template. (For example,
JOB^TYPE(*).)
FORMAT { C | [ANSI|TANDEM] COBOL85 | PASCAL | SQL | TAL }
specifies the language format for the record definition.
The default depends on the environment. In a C program, the default is C; in a TAL
program, the default is TAL; and so forth. In SQLCI, the default is SQL.
The COBOL85 format can be ANSI or TANDEM. In ANSI format, each fixed format
line has a sequence number and contains a maximum of 80 characters; in
TANDEM format, a free format line has no sequence number and contains a
maximum of 132 characters. The default for COBOL85 is TANDEM COBOL85.
LEVEL { base }
{ ( base, inc ) }
(for use in COBOL programs or from SQLCI) specifies an integer in the range 1 to
49 as the base level number for a COBOL85 record definition and, optionally, an
integer in the range 1 to 24 as the increment used to assign level numbers to data
items (columns) in the record.
The base plus two times the increment must not exceed 49. If the increment is too
large, SQL issues a warning and uses 1. The default is LEVEL 01, 01.
DATEFORMAT { DEFAULT | EUROPEAN | USA }
specifies the format of host variables for date-time columns.
For a column with a date-time data type that has an HOUR field, DATEFORMAT
USA causes INVOKE to produce a host variable that is three bytes longer than an
equivalent host variable for EUROPEAN or DEFAULT format. The extra bytes
allow room for “am” or “pm” following the values.
For information on the DEFAULT, EUROPEAN, or USA formats, see Date-Time
Literals on page D-10.
The default is DATEFORMAT DEFAULT.
{| PREFIX indicator-prefix |}
{| SUFFIX indicator-suffix |}
specifies a prefix, a suffix, or both for indicator variable names. The names have
the form:
indicator-prefix column-name indicator-suffix