SUPPORT / SAMPLES & SAS NOTES
Problem Note 20869: A DB2 error might occur when you call a DB2 stored procedure running SAS/ACCESS® Interface to DB/2 on z/OS
 |  |  |  |  |
If you attempt to call a DB2 stored procedure that contains more than 30
parameters, the following DB2 error message results:
-312 variable-name IS AN UNDEFINED OR UNUSABLE HOST VARIABLE OR IS
USED IN A DYNAMIC SQL STATEMENT OR A TRIGGER DEFINITION
Even though the error is coming from DB2, the error is not caused by a
DB2 problem. It is due to the fact that SAS/ACCESS Interface to DB/2
allows a maximum of only 30 parameters.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 | 9.2 TS1M0 |