The following limits apply to TABLE requests:

• Number of verb objects referenced in a TABLE request: 1024 (495 for MATCH requests)
• Number of columns of report output: 1024
• Total length of all fields in the request or in a single Master File: 256K
• Total number of sort fields (combined BY and ACROSS): 128

  An internal sort will be generated automatically under some circumstances, and these have to be counted in the total. HOLD FORMAT FOCUS/XFOCUS will add FOCLIST as a BY field in order to ensure uniqueness.

• Maximum size of the output record: 256K (FORMAT/USAGE)
• Maximum size of the output file: FOCUS partition 2GB, XFOCUS 32GB
• Maximum size of internal expression representation of a single DEFINE, COMPUTE, -SET, or WHERE phrase: 64K

  The internal representation is generated in polish postfix notation, which is significantly smaller than the entered expression. In addition, the constants in expressions (as in DECODE or IF…THEN..ELSE conditions) are stored outside of the expression representations, reducing the space requirement for the expression representation itself.

• Maximum number of segments in a structure or file: 512.

  This means that a total of 511 JOINs can be in effect at any one given time.

  Note: FOCUS data sources are limited to 64 segments.

• Maximum size of Alphanumeric fields: 4K characters ( in UTF, this means 12K bytes)
• Maximum number of display commands in a TABLE request: 16