IBM Support

IC87342: 'WARNING! AVOID_EXECUTE HAS BEEN SET' SHOULD BE PRINTED WHEN 'AVOID_EXECUTE' IS ON AND QUERY IS RUN

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • From documentation:
    
      Using the AVOID_EXECUTE Option
      [...]
      When AVOID_EXECUTE is set, the database server sends a warning
    message. If you are using DB-Access, it displays a text message
    
      Warning! avoid_execute has been set
    
      for any select, delete, update or insert query operations.
    
    This is not the case. 'No rows found.' is printed instead for
    any select, delete, update or insert run.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Everyone attempting to use this feature/behavior             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to next release of IDS 11.70 or 12.10.               *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC87342

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B70

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-18

  • Closed date

    2014-02-26

  • Last modified date

    2014-02-26

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

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

Fix information

Applicable component levels

  • RB70 PSY

       UP

  • RC10 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
26 February 2014