Ansicht
Dokumentation

CPD4311 - Maximum record length exceeded for query format &1. ( OS/400 )

ROGBILLS - Synchronize billing plans   General Data in Customer Master  
This documentation is copyright by IBM.


Message : CPD4311
Maximum record length exceeded for query format &1.

Message Long Text :

Cause . . . . . : Query format &1 has a record length of &2. A query record format cannot exceed 32,766 bytes when all fields are fixed length and non null-capable. The maximum length of the format is less if any fields in the format are variable length or are null-capable, or if ordering or distinct processing is being done. See reason code &3 below. The reason codes and their meanings follow:
1 - The specified record format exceeds the maximum record length.
2 - An INSTEAD OF trigger is being used and the extra fields added for it exceed the maximum record length.
Recovery . . . : Either specify fewer fields to be returned or remove the INSTEAD OF trigger for reason code 2. Refer to the DDS topic collection in the Programming category in the IBM i Information Center book, http://www.ibm.com/systems/i/infocenter/, for more details on the storage required for variable length and null-capable fields. The maximum record length is 3,758,096,383 bytes when a LOB field is in the format. Refer to the DB2 for IBM i SQL Reference topic collection in the Database category in the IBM i Information Center book for more details on the storage required for LOB fields.

Message File : QCPFMSG
Library Message File : QSYS2924


General Data in Customer Master   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.

Length: 3237 Date: 20240425 Time: 002100     sap01-206 ( 3 ms )