SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
I-25
INVOKE Directive and Command
INVOKE Directive and Command
INVOKE is a directive or SQLCI utility command that produces a record description
that corresponds to a row in a specified table or view.
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 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.
[| 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 } |]