A fix is available
APAR status
Closed as program error.
Error description
Admin Tool: DDL Generation with Mask is not generating DDL DESCRIPTION: When DDL generation is called with Mask option 'YES', GEN cannot complete the request. This is due to a parser error, where the parser is having trouble tokenizing the view statement, specifically because of a word that starts with a "_". The fix will be to have the parser be able to read this correctly.
Local fix
na
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * who process SQL statements with a SELECT * * * clause that includes a subselect. * **************************************************************** * PROBLEM DESCRIPTION: SQL parsing does not completely support * * a subselect nested within a SELECT * * * clause. Certain subselects in this * * scenario cause an error while parsing * * the statement and may result in * * message MSGADB1847 being issued. * **************************************************************** SQL parsing is updated to properly support an SQL statement with a SELECT * clause that includes a subselect. Keywords: ADB1847E MSGADB1847E
Problem conclusion
The problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH46375
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-05-12
Closed date
2022-12-09
Last modified date
2023-01-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI83662 UI83663
Modules/Macros
ADB27AC ADB28MC ADB2CID ADB2CM1 ADB2CM3 ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2FMT ADB2MSK ADB2MSQ ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2REG ADB2REH ADB2REM ADB2WCL ADB2WIN ADB2WVL ADBASW ADBCCM ADBCCMM ADBCDTS ADBCEST ADBCHST ADBCRCR ADBCSPG ADBDAT ADBDK ADBLI ADBNSPB ADBPA ADBPA1 ADBTEP2 ADBTEPI ADBTEPR ADBTEPU ADBV99
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 January 2023