Processing-Limits Section
Use the Processing-Limits section to define the sizes and limitations of some of the internal structures used by SQR; these definitions directly affect memory requirements. The entries are the same as those used in the file specified with the -MFILE command-line flag. If the -MFILE command-line flag is used, the Processing-Limits section of the file is not processed.
This table describes some of the internal structures used by SQR:
Entry |
Default Value |
Maximum Value |
Entry Size |
Description |
---|---|---|---|---|
|
100 |
2147450879 |
4 |
Number of BREAK arguments allowed for each EVALUATE or IF command. |
|
1500 |
2147450879 |
14 |
Maximum number of dynamic SQL arguments. |
|
65535 |
2147450879 |
1 |
Maximum length, in bytes, of temporary string storage used during LET operations. |
|
1000 |
2147450879 |
8 |
Maximum number of column forward references. |
|
32K-2 |
2147450879 |
1 |
Maximum buffer size to transfer text and image data in bytes. |
|
75 |
2147450879 |
8 |
Maximum number of ON-BREAK LEVEL=values per SET. |
|
5000 |
2147450879 |
14 |
Maximum number of placement parameters, for example, (10,5,30). |
|
131106 |
2147450879 |
2 |
Maximum number of arguments for all program lines. This value is generally 3 or 4 times the value set for PROGLINES. |
|
65535 |
2147450879 |
8 |
Maximum number of program lines (SQR commands). |
|
1000 |
2147450879 |
60 |
Maximum number of BEGIN-SQL and BEGIN-SELECT paragraphs. This value is database dependent and can vary. This size is a close approximation. |
|
4000 |
2147450879 |
6 |
Maximum number of arguments (bind variables) for all SQL or SELECT statements. The number of arguments required is one more than the number used in your report file. |
|
30000 |
2147450879 |
1 |
Maximum length of an SQL statement in characters. |
|
65535 |
2147450879 |
1 |
Maximum size of string space for program line arguments, in bytes. |
|
3000 |
2147450879 |
8 |
Maximum number of runtime substitution variables. |
|
32767 |
2147450879 |
18 |
Maximum number of variables (string, float, integer, decimal), literal values, and database columns. |
|
70 |
2147450879 |
4 |
Maximum number of WHEN arguments allowed for each EVALUATE command. |
The maximum value refers to the number of entries allowed, as shown in the previous table; however, limits are lower for 32-bit machines. In either case, SQR indicates the limit if you exceed it.
In addition to increasing the sizes, you may also decrease them to decrease the amount of memory used. Decreasing them might be advantageous, for example, for certain applications running in the PC environment, where memory is limited.
Note: Ignore the value for the keyword NUMVARIABLES that appears in $PS_HOME/sqr/pssqr.ini.