This Natural profile and session parameter is used to limit the number of database records which can be retrieved within Natural applications.
Possible settings |
|
Maximum number of records that can be retrieved. All
retrieved records (including records rejected by means of a Note: |
|
---|---|---|---|
Default setting | 99999999 |
||
Dynamic specification | yes | ||
Specification within session | yes | ||
Applicable statements | SET
GLOBALS |
Note: |
|
Applicable command | GLOBALS |
||
Application programming interface | USR1005N |
Notes:
LE
parameter
applies to all statements retrieving records from the database; that is,
statements that initiate processing loops, such as
READ
,
FIND
,
HISTOGRAM
or
SELECT
, and
statements that retrieve only a single record, such as
FIND
UNIQUE
,
FIND
NUMBER
,
FIND
FIRST
, GET
(SAME
) and
SELECT
SINGLE
.
LT
limit. The count also includes
those records which were rejected by a WHERE
clause of a
FIND
, READ
or HISTOGRAM
statement. The
LT
limit does not affect the statements
STORE
, UPDATE
, DELETE
, END
TRANSACTION
and BACKOUT TRANSACTION
.
LT
parameter. If the incremented count exceeds
the current LT
value, Natural error NAT1003
(Global limit for database calls reached
) is raised. The
count of retrieved records is reset to zero whenever a Natural program is
started on Level 1. The count is not reset if the program on Level 1 invokes
another Natural object (for further information, see
Multiple
Levels of Invoked Objects in the Programming
Guide). Therefore, the LT
parameter limits
the number of records retrieved from the database by a Level 1 program and
objects invoked by that program on a level other than 1.
LT
parameter is
dynamically changed within a program by using a SET GLOBALS
LT=n
statement, the new limit value becomes
effective for the next statement that retrieves a record from the
database.
LT
can be overridden by using the session parameter
LT
.