IBM Support

PI69938: AES1004E FOUND UNSUPPORTED SYNTAX MESSAGES FOR VARIOUS ORACLE SQL CONSTRUCTS

Direct links to fixes

RAAzInstallRepository
RAAzInstall
RAAInstallRepository
RAAInstall
Rational Asset Analyzer Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer for System z Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer for System z Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer for System z Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer for System z Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer for System z Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer for System z Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 23 (6.1.0.23) for 6.1
Rational Asset Analyzer Fix Pack 23 (6.1.0.23) for 6.1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • During analysis using the RAA proprietary scanner, AES1004E
    Found unsupported syntax messages were generated for the
    following keywords:
    
    DATABASE, as in EXEC SQL DECLARE db_name DATABASE END-EXEC.
    SELECT, as in EXEC SQL EXECUTE BEGIN SELECT function(x,y) INTO
    :host_variable FROM z; END; END-EXEC.
    END-EXEC, as in EXEC SQL CONNECT :host-variable END-EXEC.
    : (colon), as in EXEC SQL EXECUTE BEGIN :a:=b(:c,:d,:e,...);
    END; END-EXEC.
    

Local fix

Problem summary

  • During analysis using the RAA proprietary scanner, AES1004E
    Found unsupported syntax messages were generated for the
    following keywords:  DATABASE, as in EXEC SQL DECLARE db_name
    DATABASE END-EXEC. SELECT, as in EXEC SQL EXECUTE BEGIN SELECT
    function(x,y) INTO :host_variable FROM z; END; END-EXEC.
    END-EXEC, as in EXEC SQL CONNECT :host-variable END-EXEC. :
    (colon), as in EXEC SQL EXECUTE BEGIN :a:=b(:c,:d,:e,...); END;
    END-EXEC.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI69938

  • Reported component name

    RATL ASSET ANAL

  • Reported component ID

    5724V2700

  • Reported release

    610

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-09-29

  • Closed date

    2017-02-28

  • Last modified date

    2017-02-28

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

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

Modules/Macros

  • SCAN
    

Fix information

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:
18 October 2021