IBM Support

PH00692: IN RDZ 9.5.1.1, SQL PARSER ERRORS WITH PARTITION BY OR OTHER XXXBY STATEMENTS WHEN FOLLOWED BY COUNT(*) OVER

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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

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



Document information

More support for: Rational Developer for System z

Software version: 951

Reference #: PH00692

Modified date: 23 October 2018