| Neueste Versionen | 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 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC71330 | Status: Geschlossen |
NO RETURN ON A Z/OS GLOBAL TEMPT TABLE ON STORED PROCEDURE | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
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-Zusammenfassung: | |
****************************************************************
* 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 | |
| verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
| Lösung | |
Please move to fix pack 4 of v9.7 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.09.2010 02.05.2011 02.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.4 |
|