IBM Support

IC81885: SQLPROCEDURECOLS RETURN DUPPLICATE ROWS WHEN THERE ARE MORE THAN ONE PROCEDURE WITH THE SAME ROUTINENAME AND SPECIFICNAME

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • db2 "CREATE TABLE newton.tabm  ( "COL1" INTEGER , "COL2" INTEGER
    ) "
    
    db2 "CREATE MODULE newton.mod1"
    db2 "ALTER MODULE newton.mod1 PUBLISH PROCEDURE
    T_NMPMODULE_SP120(IN p1 INT, OUT p2 INT) specific p1 BEGIN SET
    p2 = p1; END"
    
    
    db2 "CREATE MODULE "NEWTON  "."T_NMPMODULE_M611""
    db2 "ALTER MODULE newton.T_NMPMODULE_M611 PUBLISH PROCEDURE
    T_NMPMODULE_SP120(IN param1 INT, IN param2 INT, OUT param3 INT)
    specific p1 BEGIN SET param3 = param1+param2; END"
    
    db2 "create PROCEDURE T_NMPMODULE_SP120(IN pm1 INT, IN pm2 INT,
    OUT pm3 INT) specific p1 BEGIN SET pm3 = pm1+pm2; END"
    
    db2 "call
    sysibm.SQLProcedurecols('','%','T_NMPMODULE_SP120','%','DATATYPE
    =''ODBC''')"
    
    Above call returns 13 records but it should actually return 8
    records
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of SQLPROCEDURECOLS                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error  description                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 LUW V97 FP5                                   *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 LUW V97FP5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC81885

  • 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

    2012-03-07

  • Closed date

    2012-06-05

  • Last modified date

    2012-06-05

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

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

    IC84482

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 #: IC81885

Modified date: 05 June 2012