A fix is available
APAR status
Closed as program error.
Error description
DB2 Administration Tool for z/OS when using DDL/GEN command on a VIEW may result in message : Unexpected token after AS keyword - expected keyword select- clause ADB2PA: The following statement could not be parsed
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use DDL/GEN line command to * * generate a VIEW which has the MINUS * * keyword in the fullselect statement. * **************************************************************** * PROBLEM DESCRIPTION: When using the DDL/GEN line command * * on a VIEW which has a MINUS keyword * * in the fullselect statement, the * * following error is observed: * * * * Unexpected token after AS keyword - * * expected keyword select- clause * * ADB2PA: The following statement * * could not be parsed * **************************************************************** * RECOMMENDATION: * **************************************************************** When using the DDL/GEN line command on a VIEW which has a MINUS keyword in the fullselect statement, the following error is observed: Unexpected token after AS keyword - expected keyword select- clause ADB2PA: The following statement could not be parsed
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI43880
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-06-26
Closed date
2015-10-02
Last modified date
2015-11-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBASW ADBCCMM ADBCDTS ADBCEST ADBCRCR ADBCSPG ADBDAT ADBDK ADBLI ADBNSPB ADBPA ADBTEPI ADBTEPR ADBTEPU ADBTEP2 ADBV99 ADB2CID ADB2CMF ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2FMT ADB2MSK ADB2MSQ ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2REG ADB2REH ADB2WCL ADB2WIN ADB2WVL ADB27AC ADB28MC
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0"}]
Document Information
Modified date:
30 March 2021