The SQLIMSDA header
The fields in the SQLIMSDA header have different usage depending on whether the SQLIMSDA is being used in a DESCRIBE or FETCHstatement.
The following table describes the fields in the SQLIMSDA header.
| COBOL name | Data type | Usage in DESCRIBE | Usage in FETCH |
|---|---|---|---|
sqlimsdaid |
CHAR(8) | An eye catcherfor storage dumps, containing the text 'SQLIMSDA '. |
SQLIMSDAID is not used. |
sqlimsdabc |
INTEGER | Length of the SQLIMSDA,
equal to SQLIMSNx * 44+16. |
Length of the SQLIMSDA,
greater than or equal to SQLIMSNx * 44+16. |
sqlimsn |
SMALLINT | The field must be set to a value greater than or equal to zero before the statement is executed. The field indicates the total number of occurrences of SQLIMSVAR. In COBOL, the included SQLIMSDA contains up to 750 occurrences of SQLIMSVAR. | Total number of occurrences of SQLIMSVAR provided in the SQLIMSDA. SQLIMSN must be set to a value greater than or equal to zero. In COBOL, the included SQLIMSDA contains up to 750 occurrences of SQLIMSVAR. |
sqlimsd |
SMALLINT | The number of columns described by occurrences of SQLIMSVAR. | The number of host variables described by occurrences of SQLIMSVAR. |