This statement limits the maximum number of concurrent suborders.
Scope of validity
DBH administration
See also
The DBH option SUBORDERS on "SUBORDERS"
Function
The MODIFY-SUBORDER-LIMIT administration statement allows you to change the MAXIMUM parameter of the DBH option SUBORDERS to suit requirements.
You use this statement to change the maximum permitted number of suborders (SQL scans or logical files) in the DBH session.
MODIFY-SUBORDER-LIMIT |
LIMIT = <integer 6..262143> |
Operands
LIMIT = <integer 6..262143>
Specifies the maximum permissible number of concurrent orders.
When you enter a value for LIMIT which is lower than the total of all suborders which currently exist, SESAM/SQL determines an internal value for LIMIT. This value corresponds to the total of all current suborders of all users.
The number of parallel suborders cannot fall any lower than the number reached during the currently running DBH session.
Administration command in ISP format and at the CALL DML interface
The OPT,SUBORDERS administration command corresponds to the MODIFY-SUBORDER-LIMIT administration statement here.
OPT,SUBORDERS=n