Ansicht
Dokumentation

SQL0136 - ORDER BY, GROUP BY, or join columns too long. ( OS/400 )

TXBHW - Original Tax Base Amount in Local Currency   BAL Application Log Documentation  
This documentation is copyright by IBM.


Message : SQL0136
ORDER BY, GROUP BY, or join columns too long.

Message Long Text :

Cause . . . . . : The maximum number of elements in an ORDER BY list is 10000. The total length of all the ORDER BY elements cannot exceed 32766 bytes. The maximum number of columns in a GROUP BY list is 8000. The total length of all the GROUP BY columns cannot exceed 32766 bytes. The total length of all the join columns in an exception join or outer join cannot exceed 32766 bytes.
If the ORDER BY or GROUP BY list contains null capable columns, then an additional byte is required for each null capable column. If the ORDER BY or GROUP BY list contains varying-length columns, then the 2 byte length is included in the total length. If the allow copy data option is ALWCPYDTA(*NO), the total length of all the GROUP BY columns cannot exceed 2000 bytes.
Recovery . . . : The statement must be changed so that the length of the ORDER BY, GROUP BY, or join values does not exceed their limits. One or more column names must be removed from the clause. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


RFUMSV00 - Advance Return for Tax on Sales/Purchases   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3229 Date: 20240425 Time: 100255     sap01-206 ( 3 ms )