SQL Programming Manual for Pascal

Host Variables and Parameters
HP NonStop SQL Programming Manual for Pascal—528614-001
2-14
Using Indicator Parameters
parameter. The name of the indicator parameter follows the parameter name in the
SQL statement. For example:
INSERT INTO =employee VALUES (1000, ?p INDICATOR ?i );
If the user enters a null value for ?P, the program should set ?I to a value less than
zero. If the user enters a nonnull value, the program should set ?I to 0. Both ?P and ?I
appear in the names buffer to allow prompting the user for a null value.
For more information and examples for using parameters in dynamic SQL statements,
see Section 7, Using Dynamic SQL.