| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC71330 | Status: Closed |
NO RETURN ON A Z/OS GLOBAL TEMPT TABLE ON STORED PROCEDURE | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem 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. | |
| 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, *
* 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. *
****************************************************************
* RECOMMENDATION: *
* Please move to fix pack 4 of v9.7 *
**************************************************************** | |
| Local Fix: | |
N/A | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
| Solution | |
Please move to fix pack 4 of v9.7 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.09.2010 02.05.2011 02.05.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7. | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.4 |
|