Answer / ravi shankar porwal

In inner join only matched records of primary & secondary
will be selected.Whereas in outer join All the records of
primary file get selected with default value of secondary
file.

Answer / ravi shankar porwal

In inner join only matched records of primary & secondary
will be selected.Whereas in outer join All the records of
primary file get selected with default value of secondary
file.

Answer / kamal

In inner join means matching records in b/w the joining file will be selected.

Outer join means all records from primary file and matching records from secondary.

Answer / mathan kumar

inner join means join the file it self...
outer join means join the primary file with secondary
file..

I know chain keyword retreive records randomly but how chain keyword exactly works internally????

4 Answers  

---

3 members in a databasefile .how to read records from all the members?????????

4 Answers   CTS,

---

What will be the value of STRING after line 0106 is executed in the code below? 0101 E* Fromfiletofile..tabnameprnentlenpdatabnamlenpda 0102 E ARR 8 1 0103 ISTRING DS 0104 I 1 8 ARR 0105 C MOVE *BLANK STRING 0106 C MOVEA'ABC' ARR A) 'AAAAAAAA' B) 'BBBBBBBB' C) 'CCCCCCCC' D) 'ABC ' E) ' ABC'

2 Answers  

---

please guys help me,I need to write a program that shows more than one way to display a subfile. Both views are of the same file but sorted differently and show different fields of the same file when the user presses a function key. send me code

4 Answers   Virtusa,

---

in which journalling which attributes are necessary??/

1 Answers   CTS,

---

I have file with data as follows data 1 2 3 4 5 I need to read 1 and 5 ,then 2 and 4 then like.. upto end of file, can any one help on this

3 Answers   ISG,

---

Suppose we have 10 records with same name and we are reading using READE,after 4 record i have to use CHAIN what is the output

3 Answers  

---

How can we know running job is batch or interactive?

0 Answers  

---

how do I declare a table or array in rpg iv?

0 Answers   IBM,

---

I have some doubts on subfile----------- -----I wrote a prog on subfile to display the records. Every thing is clear but i defined a field called "opt" as input field in subfile record format from that input field i wish to enter into new screen called "EDIT" which i created it as a separate RCD in display file. i gave opt as 2 for edit just like in WRKMBRPDM screen please telll me the code and how can i code for it in RPG.

3 Answers  

---

there is any limit to display the members in rpg400?

3 Answers  

---

what is ment by "MDT"

2 Answers   TCS,

---