IBM Support

PK97784: handleHardIOErrors=no in try block does not stop program on sql failure

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • User has sql statements in try block, and no onException.
    The program properties are:
      {
      includeReferencedFunctions = yes, allowUnqualifiedItemReferenc
    es = yes,
      throwNrfEofExceptions = yes, handleHardIOErrors = no, V60Excep
    tionCompatibility = yes,
      I4GLItemsNullable = no, textLiteralDefaultIsString = no, local
    SQLScope = yes,
      inputRecord = BEEESW
      }
    On an sql error -805, however, the program does not stop but con
    tinues to run, eventually filling up spool fiels with error.
    

Local fix

Problem summary

  • When a hard SQL error occurs and when the user specifies
    that they do not wish to handle them, the flag to prevent
    any of the user's EGL try blocks from getting control was
    not being set. This caused the try block to still get
    control and the program continue.
    

Problem conclusion

  • Software updated. Fixtest available.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK97784

  • Reported component name

    RATL BUS DEV

  • Reported component ID

    5724S5000

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-02

  • Closed date

    2009-12-14

  • Last modified date

    2009-12-14

  • 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

    RATL BUS DEV

  • Fixed component ID

    5724S5000

Applicable component levels

  • R751 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
14 December 2009