IBM Support

LI75740: NO RETURN ON A Z/OS GLOBAL TEMPT TABLE ON STORED PROCEDURE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • With autocommit off when you do a select, call procedure, and
    select from a db2 connect to a z/OS from the CLP the call
    procedure and select will not return anything.
    
    Ex:
    db2 CREATE GLOBAL TEMPORARY TABLE global.abc1 (IN_TYPE
    CHARACTER(3));
    db2 +c -tvf test1_with_insert.txt
    insert into global.abc1 values('AAA')
    
    DB20000I  The SQL command completed successfully.
    
    insert into global.abc1 values('DDD')
    
    DB20000I  The SQL command completed successfully.
    
    
    
    select * from global.abc1
    
    
    
    IN_TYPE
    
    -------
    
    AAA
    
    DDD
    
      2 record(s) selected.
    
    
    
    call global.procedure1(?)
    
    O_COUNT: 0
    
    IN_TYPE
    
    
    
     "PROCEDURE3" RETURN_STATUS: 0
    
    
    
    select * from global.abc1
    
    
    
    IN_TYPE
    
    -------
    
      0 record(s) selected.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * NO RETURN ON A Z/OS GLOBAL TEMPT TABLE ON STORED PROCEDURE   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * With autocommit off when you do a select, call               *
    * procedure,andselect from a db2 connect to a z/OS from the    *
    * CLP the callprocedure and select will not return             *
    * anything.Ex:db2 CREATE GLOBAL TEMPORARY TABLE global.abc1    *
    * (IN_TYPECHARACTER(3));db2 +c -tvf                            *
    * test1_with_insert.txtinsert into global.abc1                 *
    * values('AAA')DB20000I  The SQL command completed             *
    * successfully.insert into global.abc1 values('DDD')DB20000I   *
    * The SQL command completed successfully.select * from         *
    * global.abc1IN_TYPE-------AAADDD2 record(s) selected.call     *
    * global.procedure1(?)O_COUNT: 0IN_TYPE"PROCEDURE3"            *
    * RETURN_STATUS: 0select * from global.abc1IN_TYPE-------0     *
    * record(s) selected.                                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please move to fix pack 7 of v9.5                            *
    ****************************************************************
    

Problem conclusion

  • First fixed in fix pack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI75740

  • Reported component name

    DB2 CEE LINUX

  • Reported component ID

    5765F3004

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-09-20

  • Closed date

    2010-10-25

  • Last modified date

    2010-10-25

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

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

    IC71330 IC71418

Fix information

  • Fixed component name

    DB2 CEE LINUX

  • Fixed component ID

    5765F3004

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 October 2010