Host variable references in REXX embedded SQL applications

The REXX interpreter examines every string without quotation marks in a procedure. If the string represents a variable in the current REXX variable pool, REXX replaces the string with the current value.

The following example is how you can reference a host variable in REXX:

   CALL SQLEXEC 'FETCH C1 INTO :cm' 
   SAY 'Commission = ' cm

To ensure that a character string is not converted to a numeric data type, enclose the string with single quotation marks as in the following example:

   VAR = '100'

REXX sets the variable VAR to the 3 byte character string 100. If single quotation marks are to be included as part of the string, follow this example:

   VAR = "'100'"

When inserting numeric data into a CHARACTER field, the REXX interpreter treats numeric data as integer data, thus you must concatenate numeric strings explicitly and surround them with single quotation marks.