SQL Descriptor Area (SQLDA) › SQLDA (EXECUTE, FETCH, or OPEN Statement) › SQLVAR and VS/COBOL

SQLVAR and VS/COBOL

Before you can use the SQLDA in an EXECUTE, FETCH, or OPEN statement, the SQLDATA field must be loaded with the address of the host variable that is to receive data (for that column), while the SQLIND field must be loaded (if applicable) with the address of an indicator variable.

In VS/COBOL II a "pointer" data type field can be associated with each host variable. The value in these pointer fields can be moved to the SQLDATA field to load the address of the host variable. In VS/COBOL, an Assembler subroutine must be used to determine the address of the host variable (see the example Assembler subroutine in the sample dynamic SQL program on the installation tape).