DB2 Error Code – -129 the statement contains too many table names

In this post, you’ll learn about the error message -129 the statement contains too many table names in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-129 the statement contains too many table names

Reason for the Error

A subselect (including all subqueries) can have a maximum of 15 references to table names.

Solution

Break the SQL statement into two or more simpler statements with 15 or fewer table references in each.� The count will include the number of base table occurrences from each table or view on the FROM list.