Interested to Buy Any Domain ? << Click Here >> for more details...
what is the necessary command needed before OPNQRYF and why?
- 5 Answers
- 27216 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
What are the types of identifiers?
How Chain operation copies the record's data to the input buffer for the program?
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
Explain mdt?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
can I touch the array during treatments?
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
how do I preserve and clean the array?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
write an RPG program to calculate the marks of 5 students (A,B, C, D, E)in 3 different subjects (eng, math, sci) an display on the screen
do you use message subfiles? What are the necessary keywords required coding a message subfile?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
what is the necessary keyword needed to scroll subfile records?
