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

SQL1224N DURING CREATE FUNCTION WHEN AUTO_REVAL=DEFERRED_FORCE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
When you create an SQL function in a database in which the 
AUTO_REVAL configuration parameter has been set to 
DEFERRED_FORCE, error SQL1224N will occur if any error exists 
in the function header.  For example, the following PL/SQL 
function will cause the error to occur, if user-defined type 
'numberTable2' does not exist: 
 
CREATE OR REPLACE FUNCTION NumbersBetweenPiped( 
  startValue NUMBER, 
  endValue NUMBER ) 
RETURN numberTable2 
PIPELINED 
IS 
  nCounter NUMBER; 
BEGIN 
  FOR nCounter IN startValue..endValue LOOP 
    PIPE ROW ( nCounter ); 
  END LOOP; 
END; 
/
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 Version 10.5 Fix Pack 4.                       * 
****************************************************************
Local-Fix:
Ensure that all elements in the function header (that is, 
before the first BEGIN statement) are properly defined, valid, 
and have the relevant permissions prior to issuing the CREATE 
FUNCTION statement.  Alternatively, set the AUTO_REVAL database 
configuration parameter to something other than DEFERRED_FORCE, 
to disable create-with-error semantics.
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
Delivered in DB2 Version 10.5 Fix Pack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.10.2013
08.09.2014
08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList