Referring to Host Variables

What You Can Do

CA IDMS supports references to host variables in SQL statements. The host variable name must be preceded with a colon (:).

Note: For more information about host variables, see Referring to Host Variables.

Qualifying Host Variable Names

CA IDMS supports two methods of qualifying CA ADS host variable names in an SQL statement.

For example, assume these host variable definitions:

01 EMP
     03 HIRE-DATE
 .
 .
 .
01 MGR
     03 HIRE-DATE
 .
 .
 .

The methods of qualifying HIRE-DATE in both of the following examples are valid:

EXEC SQL
  SELECT...
    INTO :HIRE-DATE OF EMP

----------------

EXEC SQL
  SELECT...
    INTO :EMP.HIRE-DATE