PI27567: ENHANCING THE PRESENTATION OF DATA FULL FORMATTING SOLUTION.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ENHANCING THE PRESENTATION OF DATA FULL FORMATTING SOLUTION
  FOR DB2 ADMINISTRATION TOOL FOR Z/OS NEW FUNCTION.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'DET - Package Details'     *
  *                 command and specify the 'E-Enhanced' (full   *
  *                 formatting) option for new field 'Format     *
  *                 type for SQL stmts'.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool now has the     *
  *                      ability to specify simple or full       *
  *                      formatting option using the DET         *
  *                      command.                                *
  *                                                              *
  *                      On panel ADB2P2 'Change DB2 Admin       *
  *                      Defaults' there is a new field          *
  *                      'Format type for SQL stmts':            *
  *                                                              *
  *                      Format type for SQL stmts . .           *
  *                             (E-Enhanced or S-Simple)         *
  *                                                              *
  *                      that will allow a user to specify       *
  *                      'E-Enhanced' or 'S-SIMPLE' option       *
  *                      for formatting SQL statements           *
  *                      when using the DET command              *
  *                      on a package on panel ADB21K            *
  *                      'Packages',                             *
  *                                                              *
  *                      The 'E-Enhanced' (full formatting)      *
  *                      option will make use of the formatter   *
  *                      module to format DECLARE CURSOR and     *
  *                      SELECT statements with host             *
  *                      variables.                              *
  *                                                              *
  *                      Help panel ADBHP2 'HELP: Change DB2     *
  *                      Admin Defaults' has been updated to     *
  *                      describe the new field:                 *
  *                                                              *
  *                      'Format type for SQL stmts              *
  *                                                              *
  *                      Specifies the format for displaying     *
  *                      SQL statements when the DET line        *
  *                      command is issued on panel ADB21K       *
  *                      'Packages'.  The DET line command       *
  *                      is used to display package details.     *
  *                                                              *
  *                      S - Displays SQL statements in simple   *
  *                          format, with chunks of 72 byte      *
  *                          text on one line and host           *
  *                          variable information on new lines.  *
  *                      E - Displays SQL statements with        *
  *                          complex nested subqueries in        *
  *                          enhanced format.  Only DECLARE      *
  *                          CURSOR and SELECT statements can    *
  *                          be displayed in the enhanced        *
  *                          format.  All other statement types  *
  *                          are displayed in simple format.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Administration Tool now has the ability to specify the
  'S-Simple' or 'E-Enhanced' (full formatting) option using the
  DET command.
  

Problem conclusion

• Enhancements delivered.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

•    ADBDK    ADBHP2   ADBTEPU  ADB2FMT  ADB2PA
  ADB2P2   H0IHB10J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI22966

     UP14/11/18 P F411

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.