|
Problem IC74670
|
Status: Closed |
db2look should generate SET CURRENT SCHEMA ddl for each PL/SQL DDLs. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The db2look output may not be directly usable if more than one
package existis with the same name under different schemas and
the orignal package DDL doesn't contain schema name.
This APAR will add the SET CURRENT SCHEMA statement. |
| Problem Summary: |
db2look should generate SET CURRENT SCHEMA ddl for each PL/SQL
DDLs. |
| Local Fix: |
modify db2look output manually |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 |
The problem is first fixed in v9.7 Fix Pack 5 (s111017) |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.02.2011
16.12.2011
16.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
