DB2 - Problembeschreibung
Problem IT04388 | Status: Geschlossen |
PARAMETER SUBSTITUTION WORKS FINE FOR SQLS, BUT NOT FOR LOAD/EXPORT/IMPORT COMMAND | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * CLPPlus users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Kepler FP5 release to fix this issue. * **************************************************************** | |
Local-Fix: | |
Lösung | |
DB2 10.5 FP5 and higher releases include this fix. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.09.2014 16.03.2015 16.03.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.5 |