Answer / uday bagdi

1) You can use primary file key field in join logical file. If your join logical file has key field then use *LOVAL SETLL. and read that file in loop.(This condition read records from start to end)
2) if your logical file not a key filed then use RRN like
1 SETLL and read that file in loop. (This condition read records from start to end)

Answer / karan

Thanks Uday it works

1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?

3 Answers   HSBC,

---

i have 6 char field in program, but this field is using in all files i want to chage field size as 10 char , how can i do this except using *like defn...?

1 Answers   IBM,

---

Thanks gagan for your answer,i'm new to as400,i don't know embedded sql in rpg.can you send me the coding for the below mentioned question in embedded sql rpg. how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.

2 Answers   iGate,

---

What is the purpose of FRCDTA keyword?

3 Answers   IBM,

---

What is the significance of UDATE?

5 Answers   IBM,

---

use of PUTOVR,OVRDTA,KEEP keywords?

2 Answers   HCL,

---

Can anybody tell me in which scenario we have to use SQLRPG .(Embeded SQL)....?

2 Answers   HSBC,

---

1.I Have a physical file , i want to read the data from the each and every member of the File in the CL Program.How do you achieve this. 2.How do you do the same in RPG?. do think is it possible to read data from all the members in the RPG?

2 Answers   Cap Gemini,

---

What is the Record Address file. How can we use it in RPG program?

4 Answers  

---

How to update only a field of a PF in an RPG program. I don't want to update the record, only one field.

2 Answers  

---

How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?

0 Answers  

---

suppose there are 100 records and i want to read records between 60-70 how we can read this 10 records in rpg

2 Answers   Polaris,

---