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.
