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

LIMIT OF 255 INCREASED TO 1012 COLUMNS FOR INLINE SQL TABLE FUNCTIONS

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Earlier versions of DB2 have a limit of 255 columns for user 
defined table functions.  The limit is documented in the "create 
function (external table)" documentation: 
 
RETURNS 
Specifies the output of the function. 
TABLE 
Specifies that the output of the function is a table. The 
parentheses that follow this keyword delimit a list of the names 
and types of the columns of the table. The list style resembles 
the style of a simple CREATE TABLE statement which has no 
additional specifications (constraints, for example). No more 
than 255 columns are allowed (SQLSTATE 54011). 
 
The same limitation was inherited implicitly by inline SQL table 
functions. 
 
With this APAR, the limit raised for inline SQL table functions, 
going up to a maximum 1012 columns.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 10.5 FP7                                          * 
****************************************************************
Local-Fix:
Lösung
First fixed in 10.5 FP7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
07.08.2015
21.01.2016
21.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList