Determining how many SQLIMSVAR occurrences are needed

The number of SQLIMSVAR occurrences needed depends on the statement that the SQLIMSDA was provided for and the data types of the columns or parameters being described.

The included SQLIMSDA provides up to 750 occurrences of SQLIMSVAR. The SQLIMSD is set to the number of columns in the result and represents the number of SQLIMSVAR occurrences needed. If an insufficient number of SQLIMSVAR occurrences were provided, IMS returns a +239 warning in SQLIMSCODE.

SQLIMSD is set to the number of columns in the result.