| Latest versions | 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 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC68746 | Status: Closed |
FOR DB2 ROUTINES WHICH ARE APPENDED WITH "COMMENTS" DURING CREAT ION, DB2LOOK FAILS TO RE-CREATE THE OBJECT FROM THE DB2LOOK OUTP | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
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 Summary: | |
**************************************************************** * 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: | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
| Solution | |
First Fixed in DB2 Version 9.7 fix pack 3 | |
| Workaround | |
not known / see Local fix | |
| BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC69079 follow-up : | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.05.2010 23.06.2010 16.09.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP3 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.3 |
|
| 9.7.0.3 |
|