Ansicht
Dokumentation

SQL0129 - Too many tables in SQL statement. ( OS/400 )

BAL Application Log Documentation   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.


Message : SQL0129
Too many tables in SQL statement.

Message Long Text :

Cause . . . . . : The SQL statement contains too many tables or views. A single SQL statement can refer to a maximum of 1000 tables or views. A CREATE TABLE AS or a CREATE VIEW statement can only refer to 256 tables. This number includes the base tables of a view.
Recovery . . . : Do one of the following and try the request again:
-- Split the SQL statement into two or more simpler statements with a maximum of 1000 tables in each.
-- If this is a CREATE VIEW or CREATE TABLE AS statement, reduce the number of tables to a maximum of 256.

Message File : QSQLMSG
Library Message File : QSYS2924


CL_GUI_FRONTEND_SERVICES - Frontend Services   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.

Length: 3219 Date: 20240426 Time: 223019     sap01-206 ( 3 ms )