DSNH129I E csectname LINE nnnn COL cc TOO MANY TABLES SPECIFIED IN SQL STATEMENT

Explanation

In a subselect, (including all subqueries), there can be no more than 225 references to table names.

System action

If the containing SQL statement is a declaration, it is discarded. If the containing SQL statement is executable, it is replaced by host language statements that will, if executed, set an error code in the SQLCA.

User response

Reduce the number of table references in each subselect. Each reference to a single table counts separately. The count only applies to table/view references in the FROM list. Each view is only counted one time.

Severity

8 (error)