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 IT02754 Status: Geschlossen

STORED PROCEDURE EXECUTION RETURNS ERROR SQL20440N WHEN ARGUMENTS ARE
SPECIAL REGISTERS AND ARRAY

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
If you have a stored procedure for which you can pass as an 
argument a special register and an array, the stored procedure 
may fail with the following error : 
SQL20440N  Array value with cardinality "1" is too long. The 
maximum cardinality allowed is "0". 
 
more repro.sql 
 
drop procedure sp1 @ 
drop type varray @ 
drop procedure test @ 
 
 
create type varray as char(12) array[5]@ 
 
create procedure sp1( 
IN v1 char(50), 
IN v2 varray, 
OUT v3 BIGINT 
 
) 
 
LANGUAGE SQL 
BEGIN 
 
 
 
END 
 
@ 
 
 
 
 
db2 call sp1(current 
time,Array['1234','345','456','789','1021'],?) 
SQL20440N  Array value with cardinality "1" is too long. The 
maximum 
cardinality allowed is "0". 
 
db2 call 
sp1('18:10:06',Array['1234','345','456','789','1021'],?) 
 
  Value of output parameters 
  -------------------------- 
  Parameter Name  : V3 
  Parameter Value : - 
 
  Return Status = 0
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 FP5 or later                             * 
****************************************************************
Local-Fix:


Lösung


The problem was first fixed in DB2 10.5 FP5


Workaround


keiner bekannt / siehe Local-Fix


Weitere Daten


Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

24.06.2014
13.03.2015
13.03.2015


Problem behoben ab folgender Versionen (IBM BugInfos)




Problem behoben lt. FixList in der Version


10.5.0.5

FixList