Answer / abhishek bajpai

It is not mandatory to use OVRDBF(*Yes) before OPNQRYF. You
can still use OPNQRYF without OVRDBF.
But here the pupose of the OPNQRYF won't be solved.
Opnqryf creates its own Open data path and to share the
same data path in a program we use ovrdbf share(*yes), if
we do not use ovrdbf, then program will have its own ODP,
so it will read the file from begining on which query has
been run. So, OPNQRYF selected records will have no
importance.
So, we need to use CPYFRMQRYF command and put the selected
records in to runtime file and use that file to read in
program.

Answer / kcsyam

OVRDBF with SHARE(*Yes) share the access path

Answer / sumit gupta

Hi guddu............
OVRDBF is not mandatory before doing OPNQRYF. OVRDBF is
only used to share the open data path within the calling
program(i.e we can use the selected records from OPNQRYF in
further program whose call is being made after
OVRDBF+OPNQRYF).

But is we dont use the OVRDBF command then open data path
will not be shared and if we done the RCVF on that file
after OPNQRYF(WITHOUT OVRDBF) then the selected records
from OPNQRYF will not be used and this RCVF will process
all the records from that file.

OVRDBF command is used just to share the open data path (By
specifying SHARE(*YES).
We we want to use the selected records from the OPNQRYF in
our further programs which call after this CL then we can
use CPYFRMQRYF command to copy all the selected records
from this OPNQRYF and then RCVF on this new file(which has
got generated by CPYFRMQRYF).

Answer / surendra y mudliar

OVRDBF command

Answer / guddu

Can any one explain Why OVRDBF is mandatory? with out that
cant we execute OPNQRYF?

i)What is the command to lock a file in a program ii)2. Can you get a level check error in a CL program

6 Answers  

Suppose i am having 3 programs PgmA,pgmB,pgmC and using source debugger. At debugging time i found that pgmC having some code error..then in debug mode directly how can i debug pgmC

2 Answers  

what are the key words you must use when using a subfile?

0 Answers   IBM,

can you debug ile rpg program using isdb?

0 Answers   IBM,

there is any limit to display the members in rpg400?

3 Answers  

how can we find setll setgt chain read reade readp operations are successfull or not,give example.explain in detail.

4 Answers   iSoft, Wipro,

why subproc not run in dftactgrp?????/plz explain

2 Answers   CSC,

Can we used ovrdbf command after the opnqry file if yes then What will be out put of your program?

4 Answers   IBM,

what is the necessary command needed before OPNQRYF and why?

5 Answers  

In RPG program one file using as a PRIMARY file while running program some of the records reading twice any body know why its happening

2 Answers  

Setps to create .csv file on IFS folder in AS/400( V4R3)....?

3 Answers   TCS,

what is program status data structure?

1 Answers   IBM,