APAR status
Closed as program error.
Error description
SQL table usage not available for some DB2 tables when the SQL statement is coded like the sample below: EXEC SQL DECLARE ZZ_TYP_0040 CURSOR WITH HOLD FOR SELECT ZZZTTYP01. PARAMID, ZZZTTYP01. KOD_PARAM FROM "ZZZTTYP" ZZZTTYP01 WHERE ZZZTTYP01.PARAMID = :PRED-XX-XX.PARAMID-0004 END-EXEC
Local fix
N/A
Problem summary
Embedded SQL DB2 table names with double-quotation are not recognized
Problem conclusion
The Cobol parser was modified to support double quoted identifiers in embedded SQL. Fix is included in v 5.1.0.0.
Temporary fix
Comments
APAR Information
APAR number
PH14455
Reported component name
APPL DISCOVERY
Reported component ID
5737B1600
Reported release
505
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-07-16
Closed date
2019-07-17
Last modified date
2019-07-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
APPL DISCOVERY
Fixed component ID
5737B1600
Applicable component levels
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSRR9Q","label":"IBM Application Discovery for IBM Z"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"505","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
17 July 2019