Ansicht
Dokumentation

SQL0614 - Length of columns for CREATE INDEX too long. ( OS/400 )

Fill RESBD Structure from EBP Component Structure   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.


Message : SQL0614
Length of columns for CREATE INDEX too long.

Message Long Text :

Cause . . . . . : The sum of the lengths of the columns specified in a CREATE INDEX exceeds the maximum of 32768 bytes. If the list contains null capable columns then an additional byte is required for each null capable column. If the index contains variable length columns, then the 2-byte length of the columns is included in the total length. The key length may be too long if an ICU (UNICODE) table is being used. The internal expansion of the key can be up to six times the user specified key length due to translation. See previous messages for details.
Recovery . . . : Reduce the length by deleting some of the columns from the CREATE INDEX column list. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


Fill RESBD Structure from EBP Component Structure   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.

Length: 3226 Date: 20240426 Time: 085221     sap01-206 ( 2 ms )