<<

Contents

Search

>>

 

EBUS_JDBC_RECORD_LIMIT

 

 

Variable

 

 

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:

START

CHANGE_FILETYPE