PH27878: ADMIN TOOL LINE COMMAND DET PANEL ADB21K MAY NOT DISPLAY COMPLETE SQL; PARSER ERRORS CURSOR NAMES MULTIPLE HYPHENS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses two issues with the DET line command on
  panel ADB21K:
  
  
  1) The DET line command may not display the complete
  SQL of the package.
  
  2) Parser errors may be encountered on DECLARE, OPEN, FETCH,
  and CLOSE CURSOR statements for cursor names containing multiple
  hyphens.
  

Local fix

• Execute the SQ line command on the package.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool and     *
  *                 Object Comparison Tool for Z/OS.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: DET command does not list all the SQL   *
  *                      statements in a package. Parser errors  *
  *                      are encountered on DECLARE, OPEN, FETCH *
  *                      and CLOSE CURSOR statements.            *
  ****************************************************************
  DET command against the package does not display SQL statements
  with statement no > 32767.
  When enhanced formatting option is selected for DET report,
  parser errors may be encountered on DECLARE, OPEN, FETCH
  and CLOSE CURSOR statements for cursor names having
  multiple hyphens .
  

Problem conclusion

• The 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:

  UI72542

Modules/Macros

• ADB0     ADB2PA   ADBDK    ADBGHV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI72542

     UP20/11/14 P F011

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.