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: DSNHSM2V
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.3 TS1M2 | 9.4 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2014-10-27 12:20:45 |
Date Created: | 2014-08-26 16:23:37 |