|
Problem IT04388
|
Status: Closed |
PARAMETER SUBSTITUTION WORKS FINE FOR SQLS, BUT NOT FOR LOAD/EXPORT/IMPORT COMMAND |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
A customer (EWE) was migrating his Oracle SAP systems to DB2 and
had additional SQL scripts which had to be migrated to "native"
DB2 code. The customer chose clpplus to run the scripts.
Parameter substitution works fine for SQLs, but not for
load/export/import commands.
I took a look at the CLPPlus limitations for issuing CLP
commands:
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.
ibm.swg.im.dbclient.clpplus.doc/doc/c0054832.html?cp=SSEPGG_10.5
.0%2F3-5-2-1-15&lang=en
And no where is it indicated that CLPPlus does not process
substitution parameters for CLP commands - thus I would consider
this a defect. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* CLPPlus users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Kepler FP5 release to fix this issue. *
**************************************************************** |
| Local Fix: |
|
| Solution |
DB2 10.5 FP5 and higher releases include this fix. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.09.2014
16.03.2015
16.03.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.5
|
 |
