[Processing-Limits] Section

Production Reporting has built-in default values as to how much memory to allocate to certain Production Reporting internal structures. In versions of Production Reporting prior to 8.0, you were required to specify how much memory to allocate for some of these internal structures. Starting with version 8.0, Production Reporting automatically adjusts the internal structures until the architectural limit is reached.

The sizes and limitations of Production Reporting’s internal structures are defined in the [Processing-Limits] section in SQR.INI. Processing limits will still be supported in this release. Unlike previous releases, however, you can only increase the default values (you cannot decrease them).

The following internal structures will now have their default sizes increased as indicated in Table 103.

Table 103. Entries for [Processing-Limits] Section

Entry	Old Default	New Default	Maximum Value	Description
BREAKS	100	1024	65535	Number of BREAK arguments allowed per EVALUATE command.
DYNAMICARGS	70	4096	32767	Maximum number of dynamic SQL arguments.
EXPRESSIONSPACE	8192	65535	65535	Maximum length, in bytes, of temporary string storage used during LET operations.
FORWARDREFS	200	1024	32767	Maximum number of column forward references.
ONBREAKS	30	1024	65535	Maximum number of ON‑BREAK LEVEL=values per SET.
POSITIONS	1800	32767	65535	Maximum number of placement parameters, "(10,5,30)".
PROGLINEPARS	18000	32767	65535	Maximum number of arguments for all program lines.
PROGLINES	5000	16384	32767	Maximum number of program lines (Production Reporting commands).
QUERIES	60	1024	32767	Maximum number of BEGIN‑SQL and BEGIN‑SELECT paragraphs.
QUERYARGS	240	4096	65535	Maximum number of arguments (bind variables) for all BEGIN-SQL or BEGIN-SELECT paragraphs.
SQLSIZE	4000	16384	65535	Maximum length of an SQL statement in characters.
STRINGSPACE	15000	32767	65535	Maximum size of string space for program line arguments, in bytes.
SUBVARS	100	4096	32767	Maximum number of substitution variables.
VARIABLES	1500	16384	32767	Maximum number of variables (string, float, integer, decimal, date), literal values, and database columns.
WHENS	70	1024	65535	Maximum number of WHEN arguments allowed per EVALUATE command.

Note:

The entries in the [Processing-Limits] section are the same as those specified with the ‑Mfile command line flag. If the ‑Mfile command line flag is used, then the [Processing-Limits] section in SQR.INI is not processed.