PI65097: SQ OUTPUT FROM PACKAGES NOT WELL FORMATTED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQL output from SQ line command on packages splits lines in
  unexpected places (for example, in the middle of column names).
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the 'SQ' line command is issued    *
  *                      on panel ADB21K 'Packages', some        *
  *                      SQL statements are split and carried    *
  *                      over onto new lines, including quoted   *
  *                      variable names, string constant etc.    *
  *                      This uneven formatting of SQL           *
  *                      statements needs to be improved.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the 'SQ' line command is issued on panel ADB21K
  'Packages', some SQL statements are split and carried
  over onto new lines, including quoted variable names,
  string constant etc.  This uneven formatting of SQL
  statements needs to be improved.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI41665 UI41666

Modules/Macros

• ADB21KSQ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI41665

     UP16/10/18 P F610

• RB20 PSY UI41666

     UP16/10/18 P F610

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.