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 / vivek

USING MEMBER MAPPING IN LF THEN THIS LF USE IN RPG PROGRAM.
LET SEE,
PF@1 CONTAIN 3 MEMBER LIKE M1,M2,M3 AND FIELDS OF
NAME AND ID
LF@1
R R1 PFILE(PF@1)
K NAME
AFTER THAT LF USE IN RPG PROGRAM. TRy now.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

935


what is sflpag and sflsiz ?

2285


what are the important factors in error message subfile ?

568


what is the maximum number of files allowed in rpg?

942


hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.

2130






how to define to define a hidden filed in dspf ?

783


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

813


all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?

2415


Using %check we are checking monika in mona what is output? What is %SCAN?

989


In Which Specs Arrays, Tables & Constants Are Defined?

704


what is the sequence when using cursor?

607


what is the purpose of ovrdta and ovrata keywords ?

888


what is overlay?

684


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)?

406


What Does Lokup Does In Tables & Arrays?

739