How does isCOBOL limit the size of database query working set for the START statement?

Question ID : 82
Created on 2009-09-02 at 1:53 PM
Author : Veryant Support [support@veryant.com]

With ACUCOBOL-GT my program used the A4GL_WHERE_CONSTRAINT external variable in order to add further constraints to the SQL SELECT statement generated for the COBOL START statement.

For example,

Move "ftest_key > 3 and ftest_key < 6" to 
   A4GL_WHERE_CONSTRAINT. 
Inspect A4GL_WHERE_CONSTRAINT replacing trailing spaces by 
   low-values. 
START FTEST-FILE KEY NOT LESS FTEST-KEY.

How can I accomplish the same thing in isCOBOL?

Answer:

You can set the external variable EDBI-WHERE-CONSTRAINT, that works the same way as A4GL-WHERE-CONSTRAINT.