A fix is available
APAR status
Closed as program error.
Error description
The GEN and DDL line command in the Admin Tool does not list the EXTERNAL NAME for a SQL type STORED PROCEDURE.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 ADMIN TOOL who use GEN and * * SQL type Stored Procedure may be affected. * **************************************************************** * PROBLEM DESCRIPTION: The GEN and DDL line command in the * * Admin Tool does not list the EXTERNAL * * NAME for a SQL TYPE STORED PROCEDURE. * **************************************************************** * RECOMMENDATION: * **************************************************************** DDL AND GEN LINE COMMAND IN ADMIN TOOL DOES NOT PRODUCE THE EXTERNAL NAME FOR LANGUAGE SQL TYPE STORED PROCEDURE
Problem conclusion
This fix provides the following capability for Stored Procedure: EXTERNAL NAME may also be specified when language=SQL . Note: Fixes for DB2 ADMIN TOOL APAR PQ76240 and DB2 Object Comparison Tool APAR PQ75892 are also included in this package. See Problem Description in the respective APARs.
Temporary fix
Comments
APAR Information
APAR number
PQ76267
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2003-07-11
Closed date
2003-08-05
Last modified date
2003-09-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB2MSK ADB2REG
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410"}]
Document Information
Modified date:
31 March 2021