Introduction › Foreign Keys › Constraint on Number of Joins

Constraint on Number of Joins

In some DBMSs, some views reference tables or views in addition to those that appear in the SQL query. In such cases, you may exceed the maximum 15 joins and receive error SQL0129N. This error states in part, “The (SQL) statement contains more than 15 tables or view names.”

If you receive this message, you can avoid excessive joins programmatically by using a high-level language containing embedded SQL. The embedded SQL in these languages can implement the equivalent of a join without actually using join.