This statement changes the maximum number of records in the sorting of a cursor table.
Scope of validity
DBH administration
See also
DBH option SQL-SUPPORT on "SQL-SUPPORT"
Function
The MODIFY-SQL-SORT-LIMIT administration statement allows you to change the INTERNAL-SORT-LIMIT parameter of the DBH option SQL-SUPPORT to suit requirements.
This statement is only permitted when the DBH supports the SQL interface.
MODIFY-SQL-SORT-LIMIT |
INTERNAL-SORT-LIMIT = <integer 1..2147483647> |
Operands
INTERNAL-SORT-LIMIT = <integer 1..2147483647>
Specifies the maximum number of records a cursor table can contain if the records are to be sorted in accordance with the cursor declaration. If the number of records found during the sort exceeds this limit value, processing of the statement is aborted.
Administration command in ISP format and at the CALL DML interface
The OPT,SORTLIMIT administration command corresponds to the MODIFY-SQL-SORT-LIMIT administration statement here.
OPT,SORTLIMIT=n