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.- SQIDThis variable contains the number of input columns (and input host variables) described by the input SQLDA array.
- SQINAMEEach 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.
- SQITYPEEach 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.
- SQINULLSEach 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'.
- SQILENEach 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.