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


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.


Article ID: 82
Created: September 2, 2009
Last Updated: September 2, 2009
Author: Support KB Author

Online URL: https://support.veryant.com/support/phpkb/article.php?id=82