Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly we can use OPNQRYF ?
- 3 Answers
- 10818 Views
- TCS, I also Faced
- E-Mail Answers
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 Is Ddm ?
How do you combine two record formats in RLU ?
what is sflinz and sflrna?
How to change file attributes such as size, file wait time, record wait time etc., permanently?
what is match field indicator?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
what is the length of a variable in rpg?
What is the purpose of PR and PI in calling program and called program? in Called program PR is compulsory?
what is the purpose of data structure?
How can we arrange duplicate records in a file?
What is access path in as400?
what the purpose of ovrdta, ovrata keywords?
RPG400 
