PH12697: DB2 ADMINISTRATION TOOL - ADB2PA PARSER ERROR WHEN CURSOR NAME HAS A DASH

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A CURSOR that has a dash in the cursor name returns a parsing
  error when an OPEN/FETCH/CLOSE statement for the cursor is
  executed.
  
     SQL stmt not completely parsed
  
     ADB2PA: The following statement could not be parsed:
  
     OPEN TSVCGRP-CSR
  
     Token number =      3, Token = -
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS or DB2 Object Comparison Tool for z/OS. *
  ****************************************************************
  * PROBLEM DESCRIPTION: Parser issues error message ADB2PA for  *
  *                      a valid OPEN, FETCH, and CLOSE          *
  *                      statement.                              *
  ****************************************************************
  Parser issues an error for valid OPEN, FETCH, or CLOSE
  statement when a cursor name in the statement has dash in it.
  
  SQL stmt not completely parsed
  
  ADB2PA: The following statement could not be parsed:
  
  OPEN TSVCGRP- CSR
  
  Token number = 3, Token = -
  
  SQL stmt not completely parsed
  
  ADB2PA: The following statement could not be parsed:
  
  FETCH TSVCGRP-CSR INTO : H , : H , : H , : H , : H , : H , : H
  : H ,
  : H , : H , : H , : H , : H , : H , : H , : H , : H , : H , : H
  , : H ,
  : H , : H , : H , : H , : H , : H , : H , : H , : H , : H , : H
  , : H ,
  : H , : H , : H , : H , : H
  
  Token number = 3, Token = -
  ***
  

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:

  UI64654

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI64654

     UP19/09/01 P F908

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.