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

in conjunction with which statements can orxx and andxx conditions be used ?

1 Answers   IBM,


Difference Between Ca & Cf?

0 Answers   IBM,


What are Triggers?

14 Answers   Ordain Solutions, Seabus Solutions,


Difference Between Skip Before & Space Before?

0 Answers   IBM,


Q.1.What is differences in STRDBG and STRISDB debugging commands? 2.Where we should use STRDBG and STRISDB Debugging commands?

6 Answers   CTS,






Describe about Query/400?

1 Answers  


when you are defining a flat file in your program in f specs which format will you specify?

1 Answers   IBM,


when should I use method get, and when should I use method post in my cgis?

0 Answers   IBM,


is it possible to do commitment control with out journaling?

1 Answers  


When will you use OPEN and CLOSE opcodes in RPG program?

1 Answers  


What is the maximum number of key fields allowed defining in a physical file?

1 Answers  


What is a job log?

1 Answers  


Categories