PK93025: ADMIN DDL/GEN ON NSP FAILED W/ ONCODE=520, SUBSCRIPTRANGE CONDITION AND NSP FAILED WITH PARSER ERROR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADMIN DDL/GEN ON NSP  FAILED W/ ONCOD=520, SUBSCRIPTRANGE
  CONDITION AND NSP FAILED WITH PARSER ERROR.
  .
  Additional symptom keywords: oncode520
  

Local fix

• APPLY PTF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of DB2  Admin Tool  or DB2 Object     *
  *                 Comparison  Tool  who use  bracketed SQL     *
  *                 comments. Also, users who use native SQL     *
  *                 procedures that contain a DECLARE CURSOR     *
  *                 statement for  a select statement with a     *
  *                 common-table-expression.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR fixes two problems:           *
  *                                                              *
  *                      1) A  parser error can occur when the   *
  *                         the users  DDL contains  bracketed   *
  *                         SQL comments (e.g. /* comment */).   *
  *                         When the statement is a native SQL   *
  *                         procedure the parser error reports   *
  *                         that  a semi-colon is missing from   *
  *                         the CREATE PROCEDURE statement.      *
  *                                                              *
  *                      2) A SUBSCRIPTRANGE condition occurs in *
  *                         the  ADD_SYMBOL_UNRESOLVED procedure *
  *                         when parsing  a native SQL procedure *
  *                         that   contains  a   DECLARE  CURSOR *
  *                         statement  for  a  select  statement *
  *                         with a common-table-expression.      *
  *                                                              *
  *                         e.g. DECLARE C1 CURSOR FOR WITH      *
  *                         common-table-expression ...          *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  1) The parser does not correctly parse bracketed comments when
     there are an odd number  of asterisks (*) before the end of
     the bracket. e.g. /*...<odd # of asterisks (*)>*/
     Where <odd # of asterisks (*)> represents an odd number of
     asterisks.
  
  2) The parser does not correctly process the DECLARE
     CURSOR    statement for a select statement with a
     common-table-expression.
  

Problem conclusion

• The problems have been fixed.
  

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

•    ADB2PA   ADB2PA5
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK49451

     UP09/08/27 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.