Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use OVRDBF command without using of OPNQRYF ?
Or can we use OPNQRYF command without using of OVRDBF
command ?
- 4 Answers
- 33363 Views
- HCL, iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / deepak
Hi Bharat,
How to use CPYFRMQRYF can you please provide its coding?
| Is This Answer Correct ? | 0 Yes | 7 No |
why is as/400 called object oriented machine?
it is possible declare variable values as variable using cl ? any cl command is there to declare values as variable
define the purpose of the iter operation?
how to define to define a hidden filed in dspf ?
Define what the operation will do, the purpose of the result field and the purpose of *IN66? HI LO EQ C CALL 'CVTDAT' DTPRM 66
I have to execute 12000 CL Commands one by one.. So, I have created a file called COMMAND. This file has only 1 field called STRING. This file had 12000 records, and all these records are CL Commands (ex: CALL PGM(PGM1)), etc) I have written a CL which will read all the record and do sbmjob.. But it is not working... Plz help me to exexute all these 12000 commands..
what does opcode post do ?
define a shared access path?
Q. 1.What are the in build functions in CL program and what are uses of thes in build functions? 2.How we can create own command in CL program? 3.What is use of STRSRVJOB?
how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.
How to read data from *LDA (Local Data Area) in RPGLE program without using IN opcode?
a program variable coded in an embedded sql statement is referred to as?
RPG400 
