Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > FETCH >

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 IBM Informix ESQL/C Programmer's Manual.

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

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]