Informix Error -7435: This statement references a table that is used in the parent queries.
Cause and resolution
This statement references a table that is used in the parent queries.
Subqueries or queries invoked by nested user-defined routines cannot reference tables used by parent queries or calling user-defined routines. Restructure your query to avoid this situation.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-7435 fires when a subquery or a query invoked by a nested user-defined routine references a table already used by a parent query or calling UDR — per the official guidance, this isn't supported.
- A nested subquery/UDR-invoked query referencing a table used by a parent query or calling UDR, per the official guidance — the direct, only cause.
Solutions / Resolution
- Restructure your query to avoid this situation, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a nested query referencing a parent-query table.
Diagnostic Checks
- Check the nested subquery/UDR-invoked query's table references against the tables used by any parent query or calling UDR, and restructure to avoid the overlap.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -7435 in this set yet.
A nested subquery or UDR-invoked query references a table already used by a parent query — restructure the query to avoid this.