PI72948: DB2 ADMIN TOOL ADB1932W USING GEN FOR A NATIVE SP WITH 'SET CURRENT TEMPORAL SYSTEM_TIME'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using GEN to generate the DDL for stored procedure with
  'SET CURRENT TEMPORAL SYSTEM_TIME', the following warning
  message is returned:
  
     Unexpected token after '....' keyword - expected keyword
               <expression>
  
     ADB1932W Parser error - the original DDL will be generated
              for the following object. Please verify the DDL.
                 Reason code = 28
                 <object name>
  
  ADB1932W/msgADB1932W
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the GEN or DDL line command on  *
  *                 a stored procedure which contains a 'SET     *
  *                 CURRENT TEMPORAL SYSTEM_TIME' in the body.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the GEN or DDL line          *
  *                      commands on a stored procedure          *
  *                      which contains 'SET CURRENT             *
  *                      TEMPORAL SYSTEM_TIME' in the            *
  *                      body, a parser error                    *
  *                      msgadb1932w / ADB1932W.                 *
  *                      is observed.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the GEN or DDL line commands on a stored procedure
  which contains 'SET CURRENT TEMPORAL SYSTEM_TIME' in the body,
  one or more of the following error messages may be observed:
  
  Unexpected token after <token name> keyword - expected
  keyword <expression>
  
  Missing semi-colon after sql_procedure_statement
  
  ADB1932W Parser error - the original DDL will be generated for
           the following object. Please verify the DDL.
           Reason code = 28
  
  For the DDL line command, the following message was also
  observed in the DDL:
  
  ADB2PA: The following statement could not be parsed :
  

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:

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI45180

     UP17/03/07 P F703

• RB20 PSY UI45181

     UP17/03/07 P F703

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.