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.
|
Authored
by: Veryant Support
This question has been viewed 6732 times so far.
|
Click
Here to View all the questions in COBOL/ESQL and Veryant ESQL Generator
category. |
File Attachments |
There are no attachment file(s) related to this question. |
|
User Comments |
|
|
There are no user comments for this question. Be the first to post a comment. Click Here |
Related Questions
|
- How do I set up isCOBOL ESQL Generator for use with Microsoft SQL Server?
- How do I use isCOBOL ESQL with Microsoft SQL Server?
- How do I migrate a Vision file to an Oracle database table?
- When to set iscobol.jdbc.autocommit=false when using ESQL
- How do I connect to a MS SQL 2005 Named Instance?
- Where is the Veryant ESQL generator? What files do I download?
- How do I get isCOBOL to create a database table when iscobol.file_suffix is set?
- How is READ NEXT implemented in isCOBOL ESQL Generator (EasyDB)?
- How is it possible to insert a NULL into an ORACLE TABLE when host variable has been initialized?
|