A fix is available
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 number
PI72948
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-30
Closed date
2017-03-02
Last modified date
2017-04-04
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 April 2017