IBM Support

PH06085: SCANNING ERRORS INVOLVING RESERVED WORDS IN SQL.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Various scanning errors  (e.g. AES1004E Found
    unsupported syntax) related to reserved words
    in SQL syntax may occur at 6.1.0.15 and above.
    

Local fix

  • none known.
    

Problem summary

  • The use of reserved words as column names caused scanning
    errors when using the WPS scanner.
    

Problem conclusion

  • The reserved words, PARTITION, SECURITY, RESULT, LANGUAGE,
    CALLER, ASSET, OPEN, RANK , PERIOD, CONTROL, NEXT, COUNT, ROLE,
    TEXT, NAME, FIRST, ASC, DESC are now added as valid names in
    the WPS scanner.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH06085

  • Reported component name

    RAA FOR SSTEM Z

  • Reported component ID

    5655W5700

  • Reported release

    610

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-12-03

  • Closed date

    2019-05-27

  • Last modified date

    2019-05-27

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • wpsscan
    

Fix information

  • Fixed component name

    RAA FOR SSTEM Z

  • Fixed component ID

    5655W5700

Applicable component levels

  • R610 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS3JHP","label":"Rational Asset Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
14 October 2021