NULL Indicator Field

Use a null indicator variable to indicate whether the associated host variable has been assigned a null value.
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.

Target:

SQL

Syntax:

SQL generates a null indicator variable in Working-Storage, defined as: 

01  IND-cursorname|IND-recordname
    05  IND-column

General Rules:

  1. When using indicator variables, prefix them with the 01 level name, because AMB can generate duplicate names with different 01 levels.
  2. When column contains an underscore, it changes to a hyphen at program generation.
  3. Normally, the IND-cursorname structure references a cursor set. To override this structure when generating indicator variables, set the &D2-USE-CURSOR-IND flag to NO in the AMB CNTL member APDB2IN. This generates the indicator variables with the IND-recordname structure.
Parent topic: Database Calls