PI76920: ISPF VIEW AS ALTERNATIVE TO BROWSE: NEW DRAW FUNCTION

Obtain the fix for this APAR.

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
  data can be edited and saved into another
  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
  ADB21T for a table which will generate
  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 clumn 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 users decides to run the SQL statement.
  

Problem conclusion

Temporary fix

Comments

• Enhancements delivered. The corresponding DB2 Administration
  Tool for z/OS Version 11, Release 1 and Version 11, Release 2
  APAR is PI72531.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI46681

Modules/Macros

•    ADBACTB1 ADBACTB4 ADBH011  ADBH1TSE ADBMAIN
  ADBPVIIF ADB2C1S  ADB21A   ADB21T   ADB21TSE ADB21VV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI46681

     UP17/04/29 P F704

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.