What will be your approach in going either for OPNQRYF or
Logical files. Which one to go for?

Answer Posted / sulthan

OPNQRYF dynamically creates the records required according
to the parameterrs and this process could be slow. While
using logic files , we already have the a record fectching
path and it is faster. so if a program needs to be run
multiple times, use LF's and if once in a while, go for opnqryf.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the key words you must use when using a subfile?

692


How to declare the pull button in AS/400..

1882


How can we override a file during runtime in rpg?

688


1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?

2373


Q:HI friends accually ihave one problem plesase let me know the alternate code of this code. Related field description of code: Add a field, CALvsPRD, "Calendar Day Starts Before/After Production Day" to the parameter set WRKORDER which accepts values 'A' or 'B' o B = Calendar Day Starts Before Production Day o A = Calendar Day Starts After Production Day o Any other value indicates the production and calendar dates are always the same. code: Automatic Execution Of *INZSR Subroutine /Z01 * retrieves WRKORDER field values. /Z01 * Calculate default Production Date and return it to caller. /Z01 * Production date defaults to system date /Z01 C Eval P@Pdate = %DATE() /Z01 * unless Calendar date starts Before PDN(production) date and /Z01 * system time is before PDN Start Time then /Z01 * PDN date is yesterday. /Z01 C If W@CALvsPRD = 'B' and /Z01 C %TIME() < %TIME (W@Strtime) /Z01 C Eval P@Pdate -= %Day(1) /Z01 * unless Calendar date starts After PDN date and /Z01 * system time is *GE PDN(production) Start Time then /Z01 * PDN date is tomorrow. /Z01 C ElseIf W@CALvsPRD = 'A' and W@Strtime > *Zero and /Z01 C %TIME() >= %TIME (W@STrtime) /Z01 C Eval P@Pdate += %Day(1) /Z01 C EndIf /Z01 C Eval *InLr = *On

2013






what is the procedure and explain about real time scenario.

1479


how do I play {insert rpg system here}?

585


can I touch the array during treatments?

758


are there any useful c runtime apis that I can call from rpg iv?

700


Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?

1462


how do you use commitment control in rpg?

757


thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

1895


how can I tell when to replace the array?

702


How to call one program from another program in RPG? please help me with the code

1260


how does the rpg element work?

716