IBM Support

IC63367: CALLING A Z/OS STORED PROCEDURE WITH NULL INPUT PARMS FROM A JAVA PROGRAM, JCC T2 OR T4, RESULTS IN ERRORCODE=-4463

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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.
    

Local fix

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

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users connecting to z/OS DB2                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When using Universal JDBC  driver, JCC T2/T4, to call a      *
    * z/OSDB2 Stored Procedure, if the input parameter has 'NULL'  *
    * asits value the result will be a -4463 error code            *
    * beingreturned.To recreate the error use the SP below being   *
    * called is asingle line test SP.CREATE TABLE TEST (ID         *
    * CHAR(20))!CREATE PROCEDURE TEST.SP_TEST(IN id                *
    * CHAR(20))LANGUAGE SQLBEGININSERT 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.  ErrorDetail: Invalid character 'N'    *
    * found in literal.Full SQL statement text=CALL SP_TEST(NULL)  *
    * ERRORCODE=-4463,SQLSTATE=42601.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 9.7 Fixpack 2.                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.7 Fixpack 2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC63367

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-23

  • Closed date

    2010-06-30

  • Last modified date

    2010-06-30

  • APAR is sysrouted FROM one or more of the following:

    IC63337

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
30 June 2010