where exactly we can use OPNQRYF ?
Answers were Sorted based on User's Feedback
Answer / guest513
OPNQRYF has multiple usages
- for dynamic selection of records, no overhead as per the
access paths.
- if needed we can create the copy of the above selected
records using CPYFRMQRYF
- to share the data path for the dynamic selected records,
so that the overhead in accessing the above records will be
simple.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / mounika
1.dynamic selection of records
2.it will use existing file access path.
3.if we want use physical members give ovrdbf(filename)mbroption(mrb1)
4.we can set rrn position to particular record.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
This is a seven part value that consists of a date (yymmdd)
and time(hhmmss and microseconds).
Which occupy 10 bytes.Cobol declaration will be X(26)
| Is This Answer Correct ? | 3 Yes | 17 No |
what does check opcode is used?
what is the difference between *like and *namvar ?
268 How many parameters can be defined in a RPG program. ?
1)In a pf if we delete a record then how to insert a new record at the same place in that pf?? any logic or code? 2)A batch job is taking a lot of time to run,found that it is going into loop and wrapping up so how to skip that loop and process the job without changing the code? 3)In which scenario C D I R comes and C D G F comes in a job? 4)If a job came to error while processing a file how we can know at which record the error hit and how to skip that record and process other records without changing program code?
What is the function of DSPATR (display attributes) keyword?
Which of the following operations does NOT zero the field FLDA defined as 4,0? C MOVE *ZEROS FLDA C Z-ADD *ZEROS FLDA C Z-ADD 0 FLDA C MOVE *ALL'0' FLDA C SUB FLDA FLDA C MOVE '0000' FLDA C CLEAR FLDA C MOVE *BLANKS FLDA
1. There is a file called Month. Month has 12 members called Jan, Feb, ..., Dec. How to design a rpg code which can access any member and show its content. (User can ask for any member when required)?
what are the different opcodes available in rpg for database access ?
how can u check no of records in a file?
What Is The Purpose Of The "n" In The Following Calculation Specification?
maximum number of subfiles that can be active for a single file is?
what is a non-join logical file?