Previous Topic: Coding Embedded SQL in AssemblerNext Topic: Host Variable Declarations for Assembler


Rules for Coding Host Variables in Assembler

When you code host variable declarations, you must comply with the following requirements:

Operand Subfields

The operand subfields:

  1. The duplication factor must be 1, regardless of whether it is explicitly specified.
  2. Valid types are listed below with the corresponding SQL type.
  3. Modifier use is limited primarily to length. Where the explicit length is specified and a nominal value is given, the explicit length takes precedence.
  4. Nominal values can be used to calculate length implicitly where no length modifier is given. A nominal value may be scanned to determine the number of decimal places.