IBM Support

IC96108: SQL ROUTINES THAT USE THE SAME VARIABLE FOR BOTH THE IN AND OUT PARAMETERS MAY RETURN NULL

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If a routine uses the same variable for both the IN and OUT
    parameters, the OUT may be NULL when the routine is called after
    it has been rebound.  The following is an example of a call to a
    routine that is using the parameters in this way.
    
    call proc1(myvar, myvar)
    

Local fix

  • The issue will not occur if an INOUT parameter is used.
    Variables that will be both passing (IN) data and receiving data
    (OUT) can be declared as INOUT rather than passing in the
    variable twice. For example if the procedure was called as
    proc1(myvar, myvar), it can be called as proc1(myvar) if an
    INOUT rather than an IN and OUT parameter is used.
    
    For additional information on the INOUT parameter please see the
    Create procedure statement at the following Infocenter page.
    
    http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2
    Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0003493.html
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * SQL Routine users                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the DB2 LUW server to version 9.7 Fix Pack 9         *
    ****************************************************************
    

Problem conclusion

  • The fix is applied to the server and was first fixed in version
    9.7 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC96108

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-19

  • Closed date

    2013-12-18

  • Last modified date

    2013-12-18

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

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

    IC96967 IC96973

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC96108

Modified date: 18 December 2013