After an upgrade to IDS version 10, 11.10, or 11.50 you see error -26060 when running a stored procedure

Flash (Alert)


Abstract

You have recently upgraded to Informix Dynamic Server (IDS) version 10, 11.10, or 11.50. You try to run a stored procedure but you see errors -597 or -26060.

Content

PROBLEM

You have recently upgraded to Informix Dynamic Server (IDS) version 10, 11.10, or 11.50. You try to run a stored procedure but you see one of these errors:


    - 26060   Procedure was created with an older version of the engine and must be dropped and created again in order to work properly.

    This procedure was created with an older version of the engine and contains statements like CREATE TRIGGER, CREATE TABLE with fragmentation expressions, ALTER TABLE or CREATE TABLE with constraint expressions or nested CREATE PROCEDURE statements. Such procedures must be dropped and created again using the current engine.


SCOPE

The following products and operating systems are affected:

Product Name
Product Version(s)
Hardware Vendor
Operating System
IBM Informix® Dynamic Server™
  • 10.00
  • 11.10
  • 11.50
  • All
    All


    CAUSE

    The product is working as designed. The stored procedure has internal information that was created using an older version of IDS that would cause the stored procedure to fail on the newer version of IDS.


    SOLUTION
    • Recreate any stored procedure containing statements like:
      • CREATE TRIGGER
      • CREATE TABLE with fragmentation expressions
      • ALTER TABLE or CREATE TABLE with constraint expressions
      • nested CREATE PROCEDURE
    • Recreate any stored procedure that returns error -26060 when it is run.

    Rate this page:

    (0 users)Average rating

    Add comments

    Document information


    More support for:

    Informix Servers

    Software version:

    7.3, 9.4, 10.0, 11.1, 11.5

    Operating system(s):

    AIX, HP-UX, Linux, Solaris, Windows

    Reference #:

    1376399

    Modified date:

    2009-02-25

    Translate my page

    Machine Translation

    Content navigation