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

DB2 RETURNS -901 FOR TARGET TYPE IS NOT TYPED WHEN COMPILING MERGE
STATEMENT

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 may throw -901 error message "target type is not typed" 
while compiling a MERGE statement whose source table is a single 
row value box involving untyped parameter marker. 
 
This creates FODC directory for APPerror  and the call stack 
looks 
 
sqlnn_cmpl 
sqlnp_main 
sqlnp_parser 
sqlnp_smactn 
sqlnq_sem_merge 
sqlnq_udi 
sqlnq_iu_convSourcePid 
sqlnq_conv_source_pid_w_ta[ 
sqlnq_pid::fix_parmm_for_a 
sqlnq_pid::fix_untyped 
 
This happens when MERGE statement has UPDATE or INSERT action, 
and target table doesn't include the target column name 
specified by UPDATE or INSERT. In other word, the MERGE 
statement has syntax error and this APAR will address this issue 
and throw the correct error message to the users.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users running  merge statement.                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to fix the issue. or use check the column     * 
* name and correct the syntax to avoid the issue.              * 
****************************************************************
Local-Fix:
Correct target column name.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
APAR will first fixed in V9.7 fixpack 8.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC89708 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.10.2012
01.04.2013
01.04.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP8
Problem behoben lt. FixList in der Version
9.7.0.8 FixList