Fixes are available
APAR status
Closed as program error.
Error description
In RDz 9.5.1.1, the SQL parser displays errors with any statement XXX BY followed by 'COUNT(*) OVER' such as SELECT COUNT(*) OVER (PARTITION BY For example, SELECT COUNT(*) OVER (PARTITION BY ABC089.UPC_13_NUM) AS COUNT_UPC_13, ABC089.UPC_13_NUM AS UPC_13_NUM ,ABC005.ITEM_DESC AS ITEM_DESC , ABC005.ITEM_UOM_CODE AS ITEM_UOM_CODE FROM ABC089UPC ABC089
Local fix
The parser does not appear to be recognizing COUNT(*) properly as replacing it with ROW_NUMBER() parses properly.
Problem summary
See error description.
Problem conclusion
The missing SQL syntax has been added. The problem listed in this APAR has been resolved with IBM Rational Developer for z Systems V9.5.1.9 Fix Pack which is available from the Recommended Fixes support download page: http://www-1.ibm.com/support/docview.wss?rs=2294&uid=swg27006335
Temporary fix
Comments
APAR Information
APAR number
PH00692
Reported component name
DEV FOR Z SYS
Reported component ID
5724T0700
Reported release
951
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-07-18
Closed date
2018-10-23
Last modified date
2018-10-23
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
DEV FOR Z SYS
Fixed component ID
5724T0700
Applicable component levels
R951 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSTRMM","label":"IBM Developer for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"951","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
16 October 2021