SQLDA Fields for Input Host Variables

SQLDA fields for input host variables updated by the
RLX
/SQL.
RLX
also supports the DESCRIBE service for the input columns and host variables of SQL statements that supply values to Db2. The REXX variables which describe input columns and their corresponding host variables, are all named SQIxxx to distinguish them from the SQLxxx variables which describe output.
  • SQID
    This variable contains the number of input columns (and input host variables) described by the input SQLDA array.
  • SQINAME
    Each occurrence of the SQINAME stemmed variable contains the name of the Db2 column for which your REXX application supplies a value. This name may be up to 18 characters long.
  • SQITYPE
    Each occurrence of the SQITYPE compound variable contains the Db2 datatype of the Db2 input column and its associated host input variable. An even value of SQLTYPE means the column does not allow nulls and an odd value means the column can assume the null value.
  • SQINULLS
    Each occurrence of the SQINULLS compound variable is set to 'Y' if null values are allowed for this Db2 column and its associated input host variable. Otherwise, SQINULLS is set to 'N'.
  • SQILEN
    Each occurrence of the SQILEN compound variable contains the Db2 internal length of the Db2 column and its associated host variable. In the case of decimal datatypes, your exec should reference the compound variables SQIPRCSN and SQISCALE, respectively, to obtain discrete values for precision and scale.