Maximum Number of Display Fields Supported in a Request

There is no limit toe the number of verb objects in a TABLE request. However, an error can occur if the report output format has a limit to the number of columns supported, the operating system has a maximum record length that cannot fit all of the columns, or the amount of memory needed to store the output is not available. The number of verb objects referenced in a MATCH request is 495. When adding fields to a request, it is important to be aware that the allowable number of fields includes all named fields, whether printed or not, including data source fields, temporary fields (virtual fields and calculated values), certain internal fields (for example, TABPAGENO), and fields used in headings and footings. The total does not include sort fields.

This field limit is also affected by the combined length of fields in the request. The field limit represents the maximum number of fields allowed when each field has the smallest length possible (A4 ACTUAL). Longer field lengths reduce the total number of printable fields.

When you create a report, the fields specified in the request are stored in a 256K (3956 bytes for MATCH requests) data area. The capacity of the data area is affected by a number of factors:

• Every field is rounded up to a full word boundary (a multiple of 4).
• Every field is associated with a four-byte counter field, which affects the total number of bytes in this data area.
• Field prefixes and formatting options affect the available data area.

If the combined length of the display fields in the data area exceeds the maximum capacity, an error message displays. To correct the problem, adjust the number or lengths of the fields in the request.