|
Problem IC82098
|
Status: Closed |
LOAD USING ADMIN_CMD RETURNS SQL1191N WHEN A DELIMITED COLUMN NAME IS SPECIFIED IN METHOD N CLAUSE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 V9.7 FP6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Problem first fixed in DB2 LUW V9.7 FP6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84523
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.03.2012
04.06.2012
04.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
