DB2 - Problembeschreibung
Problem IC63337 | Status: Geschlossen |
CALLING A Z/OS STORED PROCEDURE WITH NULL INPUT PARMS FROM A JAVA PROGRAM, JCC T2 OR T4, RESULTS IN ERRORCODE=-4463 | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / 950 - DB2 | |
Problembeschreibung: | |
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. | |
Problem-Zusammenfassung: | |
Users affected: Users connecting to z/OS DB2 with Universal JDBC Type 4 driver Problem Description: 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. Problem Summary: Customer using JDBC JCC T2/T4 to call a z/OS DB2 Stored Procedure. They are using a NULL input parameter which result in a -4463 error code returned. To recreate the error use the SP below being called is a sing 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. | |
Local-Fix: | |
Use the Legacy Type 2 JDBC driver using db2java.zip. | |
verfügbare FixPacks: | |
WebSphere MQ 5.3 for HP OpenVMS Alpha and Itanium - Fix Pack 15 | |
Lösung | |
Problem first fixed in DB2 Version 9.5 fixpak 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC63367 IC63557 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.09.2009 26.01.2010 26.01.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5. | |
Problem behoben lt. FixList in der Version |