where exactly we can use OPNQRYF ?

Answers were Sorted based on User's Feedback



where exactly we can use OPNQRYF ?..

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

where exactly we can use OPNQRYF ?..

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

where exactly we can use OPNQRYF ?..

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

Post New Answer

More IBM AS400 AllOther Interview Questions

How can we arrange duplicate records in a file?

0 Answers  


What is the purpose of 'CPYTOIMPF' command?

6 Answers   Aditya Birla, Redington,


define what a data queue is along with a brief example of what it may be used for?

1 Answers   IBM,


Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?

0 Answers  


how to toggle between single line and multi - line display of a particular record in a subfile?

1 Answers   IBM,






define the purpose of the iter operation?

1 Answers   IBM,


How many libraries can be there in library list ?

1 Answers  


hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.

0 Answers  


what are the three line types in rlu ?

1 Answers   IBM,


describe the difference between the dowxx and douxx operations?

1 Answers   IBM,


What is file access opcodes?

0 Answers   IBM,


how do we know batch job aborted after we submitting it

1 Answers  


Categories