| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC68746 | Status: Geschlossen |
FOR DB2 ROUTINES WHICH ARE APPENDED WITH "COMMENTS" DURING CREAT ION, DB2LOOK FAILS TO RE-CREATE THE OBJECT FROM THE DB2LOOK OUTP | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
For DB2 routines which are appended with "comments" during creation, like the one below: db2 "CREATE /*replace*/ or replace PROCEDURE myproc6(IN in1 smallint,IN in2 smallint,IN in3 CHAR(20)) BEGIN INSERT INTO lappanna.tab1 values(in1,in2,in3); END --comment1 --comment2 " db2look will append the terminating character in the comment line itself, like the one below: --------------------------------- -- DDL statements for stored procedures --------------------------------- SET CURRENT SCHEMA = "LAPPANNA"; SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","LAPPANNA"; CREATE PROCEDURE myproc6(IN in1 smallint,IN in2 smallint,IN in3 CHAR(20)) BEGIN INSERT INTO lappanna.tab1 values(in1,in2,in3); END --comment1 --comment2; When this db2look output is used to recreate the above procedure it fails to create that object and gives a syntax error. This is because the CLP ignores the comment line and thus the terminating character. The correct way would be db2look appends the terminating character at the next newline, like the one below: --------------------------------- -- DDL statements for stored procedures --------------------------------- SET CURRENT SCHEMA = "LAPPANNA"; SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","LAPPANNA"; CREATE PROCEDURE myproc6(IN in1 smallint,IN in2 smallint,IN in3 CHAR(20)) BEGIN INSERT INTO lappanna.tab1 values(in1,in2,in3); END --comment1 --comment2 ; | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 V97fp1 * **************************************************************** * PROBLEM DESCRIPTION: * * "db2 -tvf" fails to generate the correct DDLs as "db2look" * * doesn't generate the correct "comments" * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V97fp3. * **************************************************************** | |
| Local-Fix: | |
| verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
| Lösung | |
First Fixed in DB2 Version 9.7 fix pack 3 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC69079 Nachfolger : | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.05.2010 23.06.2010 16.09.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP3 | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.3 |
|
| 9.7.0.3 |
|