NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
I-25
INVOKE Directive and Command
The record description includes a data item for each column in the table or view except
the SYSKEY column and (except for SQL-format) an indicator variable for each
column that allows null values. The record description includes the SYSKEY column of
a view only if the view explicitly listed the column in its definition. Because INVOKE
declares host variables that are compatible with the SQL columns, no data conversion is
required at run time.
Used in a host program Declare Section, INVOKE creates a host program record
description directly in the program. Used from SQLCI, INVOKE writes the record
description on the OUT file and, optionally, in an EDIT file.
{ name }
is the name of an existing table or view for which to create a record description. It
can be a DEFINE name.
If ServerWare SMF is installed on your node, name cannot be on any $*.ZYS*.
subvolumes.
AS record
specifies the name for the record. record must be a host language identifier and
cannot be a DEFINE name.
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
[| AS record |]
[| |]
[| { C } |]
[| { [ANSI|TANDEM] COBOL85 } |]
[| FORMAT { PASCAL } |]
[| { SQL } |]
[| { TAL } |]
[| |]
[| LEVEL { base } |]
INVOKE {name} [| { ( base, inc ) } |]
[| |]
[| { DEFAULT } |]
[| DATEFORMAT { EUROPEAN } |]
[| { USA } |]
[| |]
[| { {| PREFIX indicator-prefix |} } |]
[| { {| SUFFIX indicator-suffix |} } |]
[| { } |]
[| { NULL STRUCTURE } |]
[| |]
[| TO file [ (section) ] [ CLEAR ] |]
[| |]
[| CHAR AS { STRING | ARRAY } |]