support: Customer Portal
Focused on delivering choice, investment protection and flexibility to organizations with valuable COBOL assets
 

Veryant Knowledge Base
Home > All Categories > Data Access > DBMaker (DCI) > DCI_WHERE_CONSTRAINT seems to be ignored, how can I have this feature?
Question Title DCI_WHERE_CONSTRAINT seems to be ignored, how can I have this feature?

NOTE:
Full support was added for DCI_WHERE_CONSTRAINT in version 2016R1 and the DCI Interface version 5.3.3.
The information below is only applicable to isCOBOL and DCI Interface prior versions.

The WHERE CONSTRAINT feature is supported by isCOBOL, but it's provided as callable library routine rather than an external variable.
To activate the feature in isCOBOL, after you set the DCI_WHERE_CONSTRAINT variable, call the DCI_SET_WHERE_CONSTRAINT routine passing the variable.
For example, if you have a code like this:

   MOVE "cod > 100" TO DCI_WHERE_CONSTRAINT
change it to
   MOVE "cod > 100" TO DCI_WHERE_CONSTRAINT
   CALL "DCI_SET_WHERE_CONSTRAINT" USING DCI_WHERE_CONSTRAINT
Authored by: Veryant Support This question has been viewed 4761 times so far.
Click Here to View all the questions in DBMaker (DCI) category.
File Attachments File Attachments
There are no attachment file(s) related to this question.
How helpful was this article to you?
User Comments User Comments Add Comment
There are no user comments for this question. Be the first to post a comment. Click Here
Related Questions Related Questions
There are no other questions related to this question.
Article Information Additional Information
Article Number: 231
Created: 2014-05-29 5:49 AM
Rating: No Rating
 
Article Options Article Options
Print Question Print this Question
Email Question Email Question to Friend
Export to Adobe PDF Export to PDF File
Export to MS Word Export to MS Word
Bookmark Article
Subscribe to Article Subscribe to Article
 
Search Knowledge Base Search Knowledge Base



 
 

© Veryant - All Rights Reserved
Veryant and isCOBOL are trademarks or registered marks of Veryant in the United States and other countries. All other marks are the property of their respective owners.