1. Categories >> Software >> MainFrame >> IBM AS400 >> RPG400
  2. Suggest New Category

What is the difference between inner join @ outer join

Question Posted / karthikeyan2810

Answers were Sorted based on User's Feedback



What is the difference between inner join @ outer join..

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.

Is This Answer Correct ?    7 Yes 0 No

What is the difference between inner join @ outer join..

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.

Is This Answer Correct ?    1 Yes 0 No

What is the difference between inner join @ outer join..

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.

Is This Answer Correct ?    1 Yes 1 No

What is the difference between inner join @ outer join..

Answer / mathan kumar

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

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More RPG400 Interview Questions

wat is meant by hidden field , why it is used?

4 Answers   Four soft,

can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.

0 Answers  

Write the subfile logic program for the given concept. Load the data to the subfile depends upon the designation where designation is not a key field?

2 Answers   TCS,

Difference between RESET and CLEAR

1 Answers   TCS,

When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

0 Answers  




Have a join logical file with more than one members with different record formats. So how can we read the different members from this file and also how we can read the different record format from the join logical?

3 Answers  

How to set on/off a group of indicators in a single statement?

3 Answers  

1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?

0 Answers   HCL,

Why Rpg/400 is Famous?

2 Answers   IBM,

I have two sessions S1 & S2 under this 3 jobs(say j1,j2,j3 under session S1) And 2 jobs(Say j4, j5 Under session S2)is running. How many QTEMP & how many LDA will create for the same.

9 Answers   IBM,

What is the compilation option that has to he specified while compiling an RPC program which uses a file having date data type field?

3 Answers   HSBC, IBM,

how do I preserve and clean the array?

0 Answers   IBM,

For more RPG400 Interview Questions Click Here
Categories