Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

Is This Answer Correct ?    15 Yes 0 No

where exactly we can use OPNQRYF ?..

Answer / mounika

1.dynamic selection of records 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

(1)In Cl Program,Are PGM and ENDPGM mandatery Keywords or not .If yes, please tell me why these keywords is necessary. (2)If we will not define these two keywords (PGMand ENDPGM) then any error will be come or not.

5 Answers   FIS, IBM, Virtusa,

How we can delete all the Logical File of a Physical file in one instance ?

9 Answers   IBM,

Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?

3 Answers  

What is the purpose of SFLFOLD and SFLDROP keywords?

1 Answers  

What is the purpose of OPNQRYF (Open Query File)?

1 Answers  

How many primary files allowed in a program?

1 Answers  

What is the difference between regular logical file and join logical file?

1 Answers  

what is the length of a variable in rpg?

1 Answers   IBM,

What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?

0 Answers  

i have recently moved to hyd. i would like to know which is the best institue to learn AS400. are there any in ameerpet? thanks.

4 Answers  

where can you specify an indicator in lokup operation?

1 Answers   IBM,


0 Answers   CTS, EDS,