SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

Host Variables in COBOL Programs
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
4-29
COBOL Example of Using INVOKE
COBOL Example of Using INVOKE
Example 4-4 on page 4-30 declares and uses host variable names and indicator
variable names and shows:
•
A host variable declaration with INVOKE that specifies the suffix -I for indicator
variables. The invoked record declaration is included as a comment in the
example.
•
A host variable indicator variable used in the SELECT statement. The columns that
might contain null require the indicator variable following the host variable to
receive information on nulls.
•
An indicator variable testing for null. If the value of the indicator variable following
the SELECT is less than zero, the associated column is null.
This record description is similar to the ODETAIL table of the sample database except
that the UNIT_PRICE and QTY_ORDERED columns allow null.