The following limits apply to
TABLE requests:
- 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.
- Number of verb objects referenced in a MATCH request: 495
- 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