SUPPORT / SAMPLES & SAS NOTES
Problem Note 53989: Calling a DB2 stored procedure might result in a DB2 -804 error
 |  |  |  |  |
Using explicit pass-through to call a DB2 stored procedure in the z/OS operating environment might result in errors similar to the following:
DB2 ERROR:
RESULT OF SQL STATEMENT:
DSN00804E AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS
FOR THE SQL STATEMENT, REASON 07
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 7
SQLCODE: -804 SQLSTATE: 07002 SQLERRP: DSNXECP
DB2 ERROR:
RESULT OF SQL STATEMENT:
DSN00312E VARIABLE VERS IS NOT DEFINED OR NOT USABLE
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0
SQLCODE: -312 SQLSTATE: 42618 SQLERRP: DSNHSM2VClick 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.3 TS1M2 | 9.4 TS1M0 |