PI72531: 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 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 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

• RB10 PSY UI43693

     UP17/01/06 P F701

• RB20 PSY UI43694

     UP17/01/06 P F701

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.