home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT07170 Status: Geschlossen

BLOBS ARE NOT HANDLED CORRECTLY WHEN FETCHING THE DATA FROM CURSORS OPENED
WHEN CALLING THE PROCEDURE.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Blob columns are not handled correctly in the output of queries 
called from inside procedures 
 
CLP example below can be used to reproduce the bug: 
 
create table myTable (blobCol blob(10)); 
insert into myTable values (blob(x'1122334455')), 
(blob(x'112233')), (blob(x'11')), (blob(x'667788')), 
(blob(x'66')), (blob(x'AABBCCDDEEFF')), (blob(x'AABBCC')); 
 
create or replace procedure myProc() 
  dynamic result sets 1 
  begin 
    declare txt varchar(30) default 'select blobCol from 
myTable' ;-- 
    declare cur cursor with return to client for stmt ;-- 
    prepare stmt from txt ;-- 
    open cur ;-- 
  end ; 
 
-- call query from inside procedure => wrong results 
call myProc(); 
 
  Result set 1 
  -------------- 
 
  BLOBCOL 
  ------------------------------------------- 
  x'1122334455' 
  x'112233'455' 
  x'11'233'455' 
  x'667788'455' 
  x'66'788'455' 
  x'AABBCCDDEEFF' 
  x'AABBCC'DEEFF' 
 
  7 record(s) selected. 
 
  Return Status = 0 
 
-- expected results from same query 
select blobCol from myTable; 
 
BLOBCOL 
----------------------- 
x'1122334455' 
x'112233' 
x'11' 
x'667788' 
x'66' 
x'AABBCCDDEEFF' 
x'AABBCC' 
 
  7 record(s) selected. 
 
drop table myTable;
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 CLP                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v10.5 FP7 or later fixpacks                       * 
****************************************************************
Local-Fix:
Lösung
Problem fixed in db2 v10.5 FP7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.02.2015
19.01.2016
28.04.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList