Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
FETCH statementUse the FETCH statement to move a cursor to a new row in the active set and to retrieve the row values from memory.
Using Indicator Variables

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.