DB2 CONNECT / DB2CONNCT / 910 - DB2

Customer using JDBC JCC T2/T4 to call a z/OS DB2 Stored 
Procedure. They are using a NULL input parameter which results 
in a -4463 error code returned. 
 
 
 
 
To recreate the error use the SP below being called is a single 
line test SP. 
 
 
CREATE TABLE TEST (ID CHAR(20))! 
 
CREATE PROCEDURE TEST.SP_TEST 
 (IN id CHAR(20)) 
 LANGUAGE SQL 
 
BEGIN 
              INSERT INTO TEST VALUES ('SP_TEST called'); 
END! 
 
 
The CALL statement is coded as: 
 
CALL SP_TEST(NULL). 
 
The result is: 
Error parsing literal value starting at index 21.  Error 
Detail: 
Invalid character 'N' found in literal.  Full SQL 
statement 
text=CALL SP_TEST(NULL) ERRORCODE=-4463, SQLSTATE=42601.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Java programs calling z/OS Stored procedures will Null       * 
* parameter                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Universal JDBC Type 4 client programs calls a z/OS Stored    * 
* procedure with NULL parameter which results in Errorcode     * 
* -4463.                                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.1 Fix Pack 10                   * 
****************************************************************

Use the Legacy Type 2 JDBC driver using db2java.zip.

Problem First fixed in DB2 UDB V9.1 Fix Pack 10

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

06.10.2009
16.06.2011
16.06.2011

9.1.FP10