Using Indicator Variables

Use an indicator variable if the returned data might be null.

The indicator_var parameter is optional, but use an indicator variable if the possibility exists that the value of output_var is NULL.

If you specify the indicator variable without the INDICATOR keyword, you cannot put a blank space between output_var and indicator_var.

For information about rules for placing a prefix before the indicator_var, see the HCL OneDB™ ESQL/C Programmer's Manual.

The host variable cannot be a DATETIME or INTERVAL data type.