|
Problem IC84523
|
Status: Closed |
LOAD USING ADMIN_CMD RETURNS SQL1191N WHEN A DELIMITED COLUMN NAME IS SPECIFIED IN METHOD N CLAUSE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of admin_cmd *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW V10.1 FP1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Problem fixed in DB2 LUW V10.1 FP1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.06.2012
15.11.2012
15.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
