A fix is available
APAR status
Closed as program error.
Error description
Db2 Administration Tool parser's tokenize routine does not yet support the question mark used as a stored procedure parameter marker.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * who work with stored procedures that use a * * question mark as a parameter marker * **************************************************************** * PROBLEM DESCRIPTION: When Db2 Admin Tool processes DDL that * * creates a native stored procedure, a * * question mark in the body of the stored * * procedure is not recognized as a * * parameter marker. This behavior causes * * a parsing error. * **************************************************************** The change made by this APAR allows Db2 Admin Tool to successfully process stored procedures that use question marks as parameter markers.
Problem conclusion
The problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH54720
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
2023-05-24
Closed date
2023-09-27
Last modified date
2023-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI93769 UI93770
Modules/Macros
ADB27AC ADB27AP ADB27SP ADB28MC ADB28SC ADB2CDC ADB2CID ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2DEP ADB2FMM ADB2FMP ADB2FMT ADB2IGN ADB2ISQ ADB2LCC ADB2MSK ADB2OVW ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2PRP ADB2RE ADB2REC ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2REZ ADB2RS ADB2RSD ADB2WCL ADB2WIN ADB2WVL ADB2ZPV ADB8SQL ADBAC2D ADBALT ADBASP ADBASW ADBCCM ADBCCME ADBCCMM ADBCDCH ADBCDTS ADBCEST ADBCHST ADBCIMV ADBCMPDB ADBCMTU ADBCP ADBCPRE ADBCPRM ADBCPRT ADBCRCA ADBCRCM ADBCRCP ADBCRCR ADBCSPG ADBCSQL ADBCSRV ADBCVC ADBCVCP ADBCVCT ADBCVEY ADBDAT ADBDCAC ADBDET ADBGDDL ADBGMP ADBGMSP ADBIRXF ADBLI ADBLIM ADBLIO ADBLIOB ADBMSG ADBMSGP ADBNSPB ADBPA ADBPA1 ADBPARM ADBTEPI ADBTEPU ADBVFC ADBVFCA ADBVFCF ADBVVFG
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:
03 October 2023