MODIFY-RETRIEVAL-CONTROL

This statement changes the limit value for the interruption of retrieval statements.

Scope of validity

DBH administration

See also

DBH option RETRIEVAL-CONTROL on "RETRIEVAL-CONTROL"

Function

The MODIFY-RETRIEVAL-CONTROL administration statement allows you to change the parameters INDEX-EVALUATION, USER-DATA-ACCESS and ABORT-EXECUTION of the DBH option RETRIEVAL-CONTROL to suit requirements.

MODIFY-RETRIEVAL-CONTROL

SELECT = *INDEX-EVALUATION(...) / *USER-DATA-ACCESS(...) / *ABORT-EXECUTION(...)
	*INDEX-EVALUATION(...)
		|	LIMIT = <integer 16..2147483647>
	*USER-DATA-ACCESS(...)
		|	LIMIT = <integer 1..2147483647>
	*ABORT-EXECUTION(...)
		|	LIMIT = <integer 1..2147483647>

Operands

SELECT = *INDEX-EVALUATION(...)

Specifies a limit value as of which the processing of retrieval statements is interrupted via secondary indexes and continued sequentially. The limit value refers to an expected set of records found, which the DBH calculates for the first subquestion to be processed.

LIMIT = <integer 16..2147483647>
Specifies the new limit value.

SELECT = *USER-DATA-ACCESS(...)

Specifies the number of logical USER-DATA inputs/outputs for CALL DML and SQL before there is an interruption.

LIMIT = <integer 1..2147483647>
Specifies the new limit value.

SELECT = *ABORT-EXECUTION(...)
Specifies the number of failed logical USER-DATA inputs/outputs for CALL-DML and SQL as of which the search is aborted.

A request related value defined using the pragma LIMIT ABORT_EXECUTION <integer 1. 2147483647> cannot be changed with this statement, see the “ SQL Reference Manual Part 1: SQL Statements”, section “Pragmas”.

LIMIT = <integer 1..2147483647>
Specifies the new limit value.

Administration command in ISP format and at the CALL DML interface

The OPT,RET-CON administration command corresponds to the MODIFY-RETRIEVAL-CONTROL administration statement here.

OPT,RET-CON,INDEX-EVAL=n
OPT,RET-CON,USER-DATA-ACC=y
OPT,RET-CON,ABORT=z

A number between 16 and 2³¹-1 can be specified for n.

A number between 1 and 2³¹-1 can be specified for y.

A number between 1 and 2³¹-1 can be specified for z.