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 |
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#020869A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#020869| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> DB2 |
| Date Modified: | 2007-09-04 22:51:49 |
| Date Created: | 2007-08-29 15:37:33 |