IBM Support

IT02876: 768: INTERNAL ERROR IN ROUTINE OPJOIN() WITH MULTIPLE JOINS AND LEFT OUTER JOIN

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • 768: Internal error in routine opjoin()
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * users of 12.10.xC1 through 12.10.xC4.                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * A complex ANSI JOIN query involving views may return -768    *
    * error under the following conditions:                        *
    *   - a view with multiple tables (>5) and has only inner      *
    * joins in its definition                                      *
    *   - a main query with ANSI OUTER JOIN, where the view        *
    * reference is used as a dominant table in the query           *
    *   - there exists multiple join predicates among the multiple *
    * tables used in the view definition                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IDS-12.10.xC5                                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IDS-12.10.xC5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT02876

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-06-30

  • Closed date

    2015-10-16

  • Last modified date

    2015-10-16

  • 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

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

  • RC10 PSN

       UP



Document information

More support for: Informix Servers

Software version: C10

Reference #: IT02876

Modified date: 2015-10-16