Informix Error -26082: CONNECT_BY_ISCYCLE is used without the NOCYCLE keyword.
Cause and resolution
CONNECT_BY_ISCYCLE is used without the NOCYCLE keyword.
The CONNECT_BY_ISCYCLE keyword is used without the NOCYCLE keyword in a CONNECT BY query. Include the NOCYCLE keyword in the CONNECT_BY_ISCYCLE context.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26082 fires when CONNECT_BY_ISCYCLE is used in a CONNECT BY query without the
NOCYCLE keyword — per the official guidance.
CONNECT_BY_ISCYCLEused withoutNOCYCLEin the sameCONNECT BYclause, per the official guidance — the direct, only cause;CONNECT_BY_ISCYCLEonly makes sense when cycling rows are being skipped viaNOCYCLE.
Solutions / Resolution
- Include the
NOCYCLEkeyword in theCONNECT BYclause, per the official guidance.
Examples
CONNECT_BY_ISCYCLE without NOCYCLE
SELECT emp_id, CONNECT_BY_ISCYCLE
FROM employees
CONNECT BY PRIOR emp_id = mgr_id;
-- -26082: NOCYCLE is missing
Corrected
SELECT emp_id, CONNECT_BY_ISCYCLE
FROM employees
CONNECT BY NOCYCLE PRIOR emp_id = mgr_id;
Diagnostic Checks
- Check every
CONNECT BYclause usingCONNECT_BY_ISCYCLE, and confirm it also includesNOCYCLE.
Related Errors / Related Topics
- -26079 — "CONNECT BY query resulted in a loop." The related error this pairing is
meant to help diagnose and skip via
NOCYCLE/CONNECT_BY_ISCYCLE.
CONNECT_BY_ISCYCLE was used without NOCYCLE in the same CONNECT BY clause — add
NOCYCLE.