Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

what does check opcode is used?

1 Answers   IBM,


what is the difference between *like and *namvar ?

1 Answers   IBM,


268 How many parameters can be defined in a RPG program. ?

1 Answers  


1)In a pf if we delete a record then how to insert a new record at the same place in that pf?? any logic or code? 2)A batch job is taking a lot of time to run,found that it is going into loop and wrapping up so how to skip that loop and process the job without changing the code? 3)In which scenario C D I R comes and C D G F comes in a job? 4)If a job came to error while processing a file how we can know at which record the error hit and how to skip that record and process other records without changing program code?

1 Answers   JDA,


What is the function of DSPATR (display attributes) keyword?

1 Answers  


Which of the following operations does NOT zero the field FLDA defined as 4,0? C MOVE *ZEROS FLDA C Z-ADD *ZEROS FLDA C Z-ADD 0 FLDA C MOVE *ALL'0' FLDA C SUB FLDA FLDA C MOVE '0000' FLDA C CLEAR FLDA C MOVE *BLANKS FLDA

1 Answers  


1. There is a file called Month. Month has 12 members called Jan, Feb, ..., Dec. How to design a rpg code which can access any member and show its content. (User can ask for any member when required)?

0 Answers  


what are the different opcodes available in rpg for database access ?

1 Answers   IBM,


how can u check no of records in a file?

0 Answers   IBM,


What Is The Purpose Of The "n" In The Following Calculation Specification?

0 Answers   IBM,


maximum number of subfiles that can be active for a single file is?

1 Answers   IBM,


what is a non-join logical file?

1 Answers   IBM,


Categories