Ansicht
Dokumentation

SQL0631 - Foreign key for referential constraint &1 in &2 too long. ( OS/400 )

General Data in Customer Master   Vendor Master (General Section)  
This documentation is copyright by IBM.


Message : SQL0631
Foreign key for referential constraint &1 in &2 too long.

Message Long Text :

Cause . . . . . : The FOREIGN key cannot be created for constraint &1 in &2. Either more than 120 columns were specified in a FOREIGN KEY clause or the sum of the lengths of the columns specified in the key exceeds the maximum of 32768 bytes. If the list contains null capable columns then an additional byte is required for the length of each null capable column. If the list contains variable length columns, then the 2-byte length of the columns is included in the total length.
Recovery . . . : Remove some of the columns from the FOREIGN KEY clause. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


ROGBILLS - Synchronize billing plans   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by IBM.

Length: 3239 Date: 20240426 Time: 171820     sap01-206 ( 2 ms )