Null or truncation indicator variables in REXX embedded SQL applications

An indicator variable data type in REXX is a number without a decimal point.

The following is an example of an indicator variable in REXX using the INDICATOR keyword.

   CALL SQLEXEC 'FETCH C1 INTO :cm INDICATOR :cmind' 
   IF ( cmind < 0 ) 
      SAY 'Commission is NULL'

In the previous example, cmind is examined for a negative value. If it is not negative, the application can use the returned value of cm. If it is negative, the fetched value is NULL and cm must not be used. The database manager does not change the value of the host variable in this case.