Informix Error -749

Reasons / Common Causes

-749 fires when an external database server older than Version 5.01 sends a triggering statement or cursor operation — per the official guidance, this specific cross-server interaction isn't supported with servers that old.

1. A cross-database/distributed operation involving an external server running a version before 5.01, per the official guidance — the direct, only cause.
2. A mixed-version environment where some servers were upgraded and others weren't, and a distributed operation happened to route through one of the un-upgraded ones.

Solutions / Resolution

1. Upgrade the external database server to Version 5.01 or later, per the official guidance's implied requirement — this is the only documented path, since the restriction is version-based, not configurable.
2. Avoid routing this specific cross-server operation through the older server, as a temporary workaround, if upgrading isn't immediately possible and an alternative path exists.
3. Confirm which specific external server is involved, since the error doesn't necessarily make that obvious from the local session's perspective alone — check the distributed query/trigger's cross-server references.

Examples

Checking server versions in a distributed environment

$ onstat -    -- run against each server involved in the distributed operation
-- compare each reported version against 5.01

Diagnostic Checks

1. Identify every external server involved in the distributed operation/trigger, and check each one's version against the 5.01 minimum.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -749 in this set yet.

A hard version floor for this specific cross-server interaction — identify and upgrade the pre-5.01 external server involved.