EBUS_JDBC_RECORD_LIMIT
|
Meaning: |
Specifies
the number of data records that are read from a JDBC Index File with the
instruction START. If
the instruction START is called with a JDBC Index File, the SQL
command SELECT is executed via JDBC. From that point in the Index File, which
is specified by the key fields, all following data recods are read until the
end of file. With big Index Files this may cause performance problems since
many data records must be read from the SQL database, although only few data
records are read with READ-NEXT in the program. EBUS_JDBC_RECORD_LIMIT
specifies the maximum number of data records to be read, on the condition
that the SQL database allows to limit the number of data records to be
read. This is the case with the common databases (IBM DB2, Oracle,
Informix, MySQL, SQL-Server). If the end or the beginning of the read data
records is reached with READ-NEXT or READ-PREVIOUS, the next or previous
EBUS_JDBC_RECORD_LIMIT data records are read automatically from the SQL
database. This
variable is set to 100 at the start of the program. |
|
Changeable: |
Yes |
|
See also: |
|