PM01363: GEN/DDL OF SP FAILS WITH RC28 AND MESSAGE SPECIAL REGISTER ERROR AFTER CURRENT OR MESSAGE MISSING <SELECT-LIST> OR * AFTER SELECT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN and DDL commands
  against a procedure fail return code 28 with the message:
    Missing <select-list> or * after SELECT
  or:
    Special register error after CURRENT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the GEN or DDL command on a native   *
  *                 SQL procedure that contains the WHERE        *
  *                 CURRENT OF clause in an UPDATE statement.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: A parser error occurred when processing *
  *                      the native SQL procedure. Example       *
  *                      error message below:                    *
  *                      Special register error after CURRENT    *
  *                                                              *
  *                      ADB1847E WARNING : Error parsing DDL    *
  *                      NSP statement. Please verify the        *
  *                      generated DDL                           *
  *                                  Reason code = 28            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The parser did not support positioned-update in an UPDATE
  statement.
  

Problem conclusion

• The problem has 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
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK53038

     UP09/12/25 P F912

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.