I am using OVRDBF command in my cl program in order to apply a particular select criteria on a database file in order to pass it to the RPGLE code.
The syntax I used is as below:
OVRDBF FILE(MYFILE) TOFILE(MYFILE) +
MBR(MYFILE) OVRSCOPE(*JOB) SHARE(*YES)
OPNQRYF FILE((MYFILE *FIRST *ONLY)) OPTION(*ALL) +
QRYSLT('MYCODE *EQ "R"') OPNID(MYFILE)
Now when I debug my code and execute the above steps successfully, I go to SQL command line in my same session using shift F9 and try to query the same file for other values of MYCODE and they are visible.
Could anyone please help me in achieving my objective of placing the filter on MYFILE with MYCODE = 'R' only so that I can pass it to subsequent functions.
Also help on grouping the fields of MYFILE during OPNQRYF will be appreciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!