A fix is available
APAR status
Closed as new function.
Error description
NEW FUNCTION: RUN AND EXPLAIN SQL STATEMENTS FROM A PROGRAM FILE
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration TOOL, who run * * SQL statements from data sets using panel * * ADB222 and would like to run or explain * * SQL statements located in a COBOL or PL/I * * program, may be affected. * **************************************************************** * PROBLEM DESCRIPTION: User can run and explain SQL statements * * from input screen or run from a data * * set but not from a program file. * * .* * * PK16493 fix provides that capability. * **************************************************************** * RECOMMENDATION: * **************************************************************** See Problem Description.
Problem conclusion
Temporary fix
Comments
A new option added to ADB222 panel edits the specified COBOL or PL/I program from which the user can select an SQL statement. Entering a RUN or EXPLAIN command will cause the selected statement to be performed or explained.
APAR Information
APAR number
PK16493
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
710
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2005-12-08
Closed date
2006-02-02
Last modified date
2006-03-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBH2 ADBH2HVR ADBH22 ADB22 ADB22EX ADB22HVR ADB22RN ADB22SQL ADB222 ADB222E ADB222MP ADB53
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
R710 PSY UK11419
UP06/02/10 P F602
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 March 2006