Ansicht
Dokumentation

SQL0101 - SQL statement too long or complex. ( OS/400 )

General Material Data   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by IBM.


Message : SQL0101
SQL statement too long or complex.

Message Long Text :

Cause . . . . . : The SQL statement is longer than the limit allowed for length or complexity. The reason code is &1. One of the following reason codes indicates the error:
1 - The total number of subselects combined using UNION, EXCEPT, and INTERSECT is greater than 256.
2 - The total number of columns, constants, and operators is greater than the SQL limits.
3 - The sum of the lengths of the non-LOB and XML columns in a select list, table, view definition, or user defined table function is greater than 32766 or the definition contains LOB or XML columns and the sum of the lengths specified on the ALLOCATE clause for varying-length fields and the non-varying field lengths is greater than 32740. The maximum length is reduced if any of the columns are varying-length or allow null values.
4 - The total number of subselects referenced in an outer subselect is greater than 256.
5 - The total length of the statement text is greater than 2097152, or the total length of the prepare attribute string text is greater than 65535.
6 - The relative position value specified on the FETCH statement is outside the range of valid values.
7 - A system name could not be generated.
Recovery . . . : Simplify the statement or divide the statement up into more than one statement and try the request again. For reason code 7, specify a different name for the table, view, index, or alias.

Message File : QSQLMSG
Library Message File : QSYS2924


BAL Application Log Documentation   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.

Length: 3230 Date: 20240426 Time: 194924     sap01-206 ( 3 ms )