|
Problem IC82098
|
Status: Geschlossen |
LOAD USING ADMIN_CMD RETURNS SQL1191N WHEN A DELIMITED COLUMN NAME IS SPECIFIED IN METHOD N CLAUSE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
admin_cmd
--------------------------------------
db2 "call admin_cmd('LOAD FROM ( SELECT \" c1 1\" FROM \"TAB1\"
) of cursor MODIFIED BY ANYORDER METHOD N(\" c1 1\") REPLACE
INTO t1(c1)')"
sql1191n Column "C1" specified in the METHOD parameter does not
exist.
db2 describe table TAB1
Data type
Column
Column name schema Data type name
Length Scale Nulls
------------------------------- --------- -------------------
---------- ----- ------
c1 1 SYSIBM INTEGER
4 0 Yes
1 record(s) selected. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of ADMIN_CMD *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW V9.7 FP6 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
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 |
Problem first fixed in DB2 LUW V9.7 FP6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84523
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.03.2012
04.06.2012
04.06.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
