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

Dear All, I have one confusion related to my platform. I am working with Wipro from last two year however still I am looking for AS400 platform kindly show me the way out of it. And please share with me the hardware knowledge that how I grow myself in hardware (AS/400) also.

1 Answers   Wipro,


What is a Join Logical File, Can it be used for Update ?

1 Answers  


how many types of display are available on as/400 for user interaction?

0 Answers   IBM,


what are necessary keywords to code message subfile?

1 Answers   IBM,


Is it possible to join the same file to itself ?

1 Answers  






how can I control the way a remote browser uses its cache?

0 Answers   IBM,


How to reverse the string in rpg

0 Answers  


what is scan and xlate?

1 Answers   IBM,


What is the use of SDA ?

1 Answers  


what is maximum number of arrays allowed in rpg?

1 Answers   IBM,


define the purpose of the leave operation?

1 Answers   IBM,


What are the record format field mapping options in cpyf?

0 Answers  


Categories