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..

The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?

6 Answers  

---

if i have three programs progA,progB and progC .now i call progB from progA. but the progB does not exist . now i want to call progC instead of starting dump. how can we achieve this.

10 Answers   Four soft,

---

How to read data from Nth member of a physical file containing some X number of members in it? "Provided member names are unknown"

4 Answers  

---

i 'm new to as/400.in an interview i was asked this question.give a practical example for passing information or data through local data area. I know only that data area is an object used to store tiny bits of data or it can store one value at a time and it is used to store frequently changing values or datas.thats all i know about data area can any one tell me how local data area and user defined data area are used to pass data between jobs with a example or coding.thanks in advance.

2 Answers   CTS,

---

WHAT IS MENT BY RECORD LEVEL IDENTIFIER ? WHAT IS THE PURPOSE OF THIS?

1 Answers  

---

how can I tell when to replace the array?

0 Answers   IBM,

---

How can you delete records form a file in rpg without using "Delete" OPCODE?

7 Answers  

---

what are the types of identifers

2 Answers   IBM,

---

HOW TO DELETE THE RECORD FROM MASTER FILE WHICH IS LINK BY ANOTHER TRASATION FILE WITH REFERTIAL INTYGRITY?

1 Answers   TCS,

---

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 receive values from a called procedure in RPG?

1 Answers  

---

How to declare the more than one file in cl/400.

13 Answers   IBM,

---