What is the difference between inner join @ outer join
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.
what is the difference between SETON RT & RETURN?
list down and describe the sub systems vailable
Are all these RPG/400 Interviewed Questions being asked recently? are current?
3 members in databasefile .how to read records from all the members??
what is the necessary keyword needed to scroll subfile records?
steps for debugging two rpg programs????
how to change the length of the field in a physicalfile?
Hi, can any one tell me :IN CASE OF SINGLE PAGE FILE HOW WILL I LOAD THE PREVIOUS PAGE WITHOUT THE USE OF SFLCLR INDICATOR ?
Interviewer asked me write down DDS for load all subfile .can anybody write dds
Suppose we add one field in physical file and this physical file is used by several programs.how do we know which program is using that file? What are the impact analysis.
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.