Declare indicator variables

You declare indicator variables in the same way as host variables, between BEGIN DECLARE SECTION and END DECLARE SECTION statements as the following example shows: 
EXEC SQL BEGIN DECLARE SECTION;
   -- put indicator variable declarations here
EXEC SQL END DECLARE SECTION;

Indicator variables can be any valid numeric host-variable data type. Usually, you declare an indicator variable as an integer. For example, suppose your program declares a host variable called name. You can declare a short integer-indicator variable called nameind, as the following example shows: 

EXEC SQL BEGIN DECLARE SECTION;
   char  name[16];
   short nameind;
EXEC SQL END DECLARE SECTION;

You can use non-ASCII (non-English) characters in indicator-variable names if your client locale supports these non-ASCII characters. For more information about how the client locale affects host-variable names, see the HCL OneDB™ GLS User's Guide.