This Natural profile and session parameter controls the action to be taken if the limit of
retrieved records was exceeded in a READ
, FIND
or HISTOGRAM
processing loop.
Possible settings | ON |
The database loop will be terminated when the
limit is reached. The program flow will continue normally with the statement
following the terminated database loop. When the execution of the Natural object is
complete, error NAT0957 (Database loop limit reached with
'LE=ON'. ) is raised.
Note: |
|
---|---|---|---|
OFF |
The database loop will be terminated when the limit is reached. The program flow will continue normally with the statement following the terminated database loop. When the execution of the Natural object is complete, no error message appears. | ||
Default setting | OFF |
||
Dynamic specification | yes | ||
Specification within session | yes | ||
Applicable statements | SET GLOBALS |
||
Applicable command | GLOBALS |
||
Application programming interface | USR1005N |
See SYSEXT - Natural Application Programming Interfaces in the Utilities documentation. |
Notes:
LE
parameter applies to READ
,
FIND
and HISTOGRAM
statements with a limit specified (see
Example).
LIMIT
statement or by specifying
an explicit limit value supplied in the database processing loop.
LE
can be
overridden by using the session parameter LE
.
DEFINE DATA LOCAL 1 EMPL-VIEW VIEW OF EMPLOYEES 2 NAME END-DEFINE READ (10) EMPL-VIEW BY NAME WRITE NAME END-READ END
LE=OFF
: after 10 records the loop ends without a message.
LE=ON
: after 10 records the loop ends with an error message NAT0957
(Database loop limit reached with 'LE=ON'
).