Can we use OVRDBF command without using of OPNQRYF ?
Or can we use OPNQRYF command without using of OVRDBF
command ?

Answers were Sorted based on User's Feedback



Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of..

Answer / bharat

OVRDBF can be used separately without opnqryf to override
the attributes of file.
Now, OPNQRYF without ovrdbf, is also possible:
opnqryf creates the 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
recoreds in to runtime file and use that file to read in
program.

Is This Answer Correct ?    43 Yes 3 No

Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of..

Answer / vaiv20

Yes it can be used when u want system to point to a
particular File/Member in a library while processing a file
in a high level pgm. Example, suppose u want to use a work
file in QTEMP , although other object of the same file
exist in the current library list. other way to achieve
this is by using Keyword EXTFILE and EXTMBR on the F spec
of that file in RPGLE pgm.
I think OPNQRYF can be used without OVRDBF but that
physical file should have been defined/changed with SHARE
(*YES). This will create a data path for the file to be
shared.

Is This Answer Correct ?    13 Yes 3 No

Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of..

Answer / geo

OPNQRYF FILE((FILENAME))

CPYFRMQRYF FROMOPNID(FILENAME) TOFILE(QTEMP/TEMP) CRTFILE
(*YES)
This will copy the records selected from Open qry file and
put it in to the Temp file in Qtem that is newly created.
One can use the file i.e. QTEMP/TEMP with the records
selectes

Is This Answer Correct ?    1 Yes 3 No

Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of..

Answer / deepak

Hi Bharat,
How to use CPYFRMQRYF can you please provide its coding?

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More IBM AS400 AllOther Interview Questions

can u plz tell me is there any difference between SHELL SCRIPT & SFTP SCRIPT? I want to run LS & GET(automatically) command from CL program....which script can be used?

1 Answers  


i have one physical file which is having two logical files. logical a have unique keyword and logical b doesnt have a unique keyword. can i give duplicate values while updating through physical file. if no why?

4 Answers   IBM,


which are the member types which seu supports?

0 Answers   IBM,


when do you explicitly open files and close files in an rpg program?

1 Answers   IBM,


how to create physical file

1 Answers  


1) Suppose we call a pgm from CL, how come AS400 system knows whether the called pgm is to be interactive one or batch one? 2)How many members can exist in a PF?

7 Answers  


Please give me the code for A=A+1 in cl program?

2 Answers  


what are the parameters required for calling ls & get command(SFTP COMMANDS) from cl progtram.... e.g call PGM(qp2shell) PARM('/qopensys/usr/bin/sh' '-c' 'sftp -b /home/mydir/tmp.txt user@host.com') Plz reply in detail...

1 Answers  


what is the function of cpyf command?

1 Answers   IBM,


A join logical file has how many record formats?

0 Answers   IBM,


Describe the function of SETGT operation in RPG language?

1 Answers  


diffrence between rename and prefix

2 Answers  


Categories