Suppose you have 3 members in a database file. How to read
records from all the members
Without using CL (OVRDBF) i.e. it should be handled
exclusively in an RPG program?

Answer Posted / syam

Create diff. 3 RUNQRY with 3 members and save it. Run this
QRY inside the RPG Program thru using EXEC CL Cammand.

Is This Answer Correct ?    4 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which type of object is used in db2/400?

639


What is the difference between non-join logical files and join logical files?

606


which are the query selection criteria, which can be given in a query?

662


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?

3054


If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?

1472






Why we are not able to perform insert delete and update operation in Join logical file?

928


maximum number of subfiles that can defined in a rpg program for one display file is?

1023


in conjunction with what other keyword must ovrdta and ovrata be used?

901


how does the runqry show the output?

874


what does vldcmdkey means?

807


WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

2028


how to write *pssr ?

629


how to run other job when one job is active?

596


how do you use exceptional write in c specs?

1134


is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?

578