|
Problem IC84523
|
Status: Geschlossen |
LOAD USING ADMIN_CMD RETURNS SQL1191N WHEN A DELIMITED COLUMN NAME IS SPECIFIED IN METHOD N CLAUSE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - 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 V10.1 FP1 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
Problem fixed in DB2 LUW V10.1 FP1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.06.2012
15.11.2012
15.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
