IBM Support

PI57998: COBOL IGYDS0225: AN EXEC SQL STATEMENT WAS FOUND,BUT THE SQL COMPILER OPTION WAS NOT IN EFFECT. THE STATEMENT WAS DISCARDE

Direct links to fixes

readme.htm
RAAzInstallRepository
RAAzInstall
RAAInstallRepository
RAAInstall
Rational Asset Analyzer Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer for System z Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer for System z Fix Pack 11 (6.1.0.11) for 6.1
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 program error.

Error description

  • RAAz 6.1.0.9 Compiler-based scanning may return analysis
    messages like:
    
    COBOL IGYDS0225: (GFPBUTDB, line:2135)An EXEC SQL statement was
    found, but the SQL compiler option was not in effect. The
    statement was discarded.
    

Local fix

  • none known.
    

Problem summary

  • COBOL code with USAGE IS SQL TYPE IS CLOB syntax was not
    properly handled by COBOL preprocessor, producing an error.
    

Problem conclusion

  • Current design is that statements with USAGE IS SQL TYPE IS
    CLOB syntax are now substituted with a working replacement
    statement.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI57998

  • Reported component name

    RATL ASSET ANAL

  • Reported component ID

    5724V2700

  • Reported release

    610

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-02-24

  • Closed date

    2016-03-10

  • Last modified date

    2016-03-10

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

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

Modules/Macros

  • cobprepr
    

Fix information

  • Fixed component name

    RATL ASSET ANAL

  • Fixed component ID

    5724V2700

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