PM19262: GEN OR DDL COMMAND ON SP FAIL RC28 WITH MESSAGE: MISSING ) AFTER LIST OF EXPRESSIONS IN SET STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool GEN and DDL commands fail on SP
  ( Stored Procedure ) of the form:
  .
   UPDATE TRE2634.TABLE1
     SET TEST_TS = (CURRENT_TIMESTAMP +
                (SELECT TEST_INT FROM TRE2634.TABLE2) DAYS);
  .
  with error messages similar to:
  .
     Missing ) after list of expressions in SET statement
     ADB1847E WARNING : Error parsing DDL NSP statement. Please
              verify the generated DDL
              Reason code = 28
     Token number =     41, Token = DAYS
  .
  Additional symptom: msgADB1847E
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who receive a parser error for      *
  *                 a statement that contains a labeled          *
  *                 duration with an expression.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The parser did not correctly parse      *
  *                      the labeled duration with an            *
  *                      expression:                             *
  *                                                              *
  *                      For example:                            *
  *                                                              *
  *                      (expression) DAYS                       *
  *                                                              *
  *                      the label duration DAYS is              *
  *                      after the expression element            *
  *                      (SELECT COUNT(*) FROM                   *
  *                      SYSIBM.SYSDUMMY1) DAYS                  *
  *                      in the following select statement:      *
  *                                                              *
  *                      SELECT (CURRENT_TIMESTAMP +             *
  *                      (SELECT COUNT(*) FROM                   *
  *                      SYSIBM.SYSDUMMY1)  DAYS)                *
  *                      FROM SYSIBM.SYSDUMMY1;                  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The parser did not correctly parse the labeled duration
  with an expression.
  

Problem conclusion

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

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK62282

     UP10/11/23 P F011

• R720 PSY UK62283

     UP10/11/23 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.