Previous Topic: Host VariablesNext Topic: Qualified Host Variable Identifiers


Indicator Variables

You cannot specify explicit indicator variables. CA Ideal manages a null value indicator to handle null eligible host variables. To access a column that can have null values, use a host variable defined as null eligible (see the section on nullable field in the "SQL Concepts and Language Elements" chapter). A non‑ideal subprogram must provide explicit indicator variables if it is passed nullable fields.

You cannot assign a null value to a host variable that is not eligible to receive nulls because it will result in a run-time error.