The sum of the lengths of the fields selected for concatenation cannot exceed 32766 bytes (maximum length) for a character or Double Byte Character Set (DBCS) CONCAT field, or 31 for a zoned decimal CONCAT field. For character or DBCS fields, this maximum is 1 less (32765) if the field is null-capable, 26 less (32740) if the field is variable length, and 27 less (32739) if it is both null-capable and variable length.
Response: Select fields whose total length does not exceed the maximum for the data type of the CONCAT field.
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.