A fix is available
APAR status
Closed as new function.
Error description
ISPF VIEW AS ALTERNATIVE TO BROWSE; NEW DRAW FUNCTION.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following enhancements are * * delivered: * * * * 1 - The 'VIEW' and 'VI' line * * command. * * 2 - The 'DRAW' command in the * * Select prototype. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following enhancements are delivered: 1 - The 'VIEW' and 'VI' line command: a - The 'VIEW' command can be used on any ISPF table display panel and will display the data in an ISPF View session. From here data can be edited and saved into another data set using ISPF view commands. b - The 'VI' line command can be used on tables, views, and aliases in the same manner that the 'BR - Browse' line command is used today. When executing the 'VI' line command, ISPF View will be used instead of ISPF Browse. 2 - To use the 'DRAW' line command, issue 'SEL' command on panel ADB21T for a table which will generate panel ADB21TSE 'Build SQL Select Prototype'. The 'DRAW' command will generate an SQL SELECT statement with all columns in the select-list, one column per line with the column name, followed by a SQL comment with the column type, and optionally the length or scale, and precision of the column. The SQL comment will be removed before the statement is passed to DB2 when the user decides to run the SQL statement.
Problem conclusion
Temporary fix
Comments
Enhancements delivered.
APAR Information
APAR number
PI72531
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-18
Closed date
2017-01-05
Last modified date
2017-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI43693 UI43694
Modules/Macros
ADBACTB1 ADBACTB4 ADBA1TC ADBA1TG ADBA1TH ADBA1TM ADBA1TP ADBA1TV ADBA1TX ADBH011 ADBH1TSE ADBMAIN ADBPVIIF ADB2C1S ADB21A ADB21T ADB21TSE ADB21VV
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.
[{"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":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 February 2017