NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
I-26
INVOKE Directive and Command
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 COBOL85 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.
See DATE-TIME Literals
on page D-9 for detailed descriptions of DEFAULT,
EUROPEAN, or USA formats.
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