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

Estimated Reading Time: < 1 Minute

82 Support KB Author September 2, 2009 COBOL/ESQL and Veryant ESQL Generator 6803

Question:

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.

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

Estimated Reading Time: < 1 Minute Support KB Author September 2, 2009 6803