Interested to Buy Any Domain ? << Click Here >> for more details...
What is left outer join?
- 2 Answers
- 9636 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / syam
This is using in SQL
A left outer join will return all the rows that an inner
join returns plus one row for each of the other rows in the
first table that did not have a match in the second table.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kapil kumar
We can also use this concept in as400
JDFTVAL is a file level keyword used in Join Logical File.
It also act as left outer join.
| Is This Answer Correct ? | 5 Yes | 0 No |
What is logical file in as400? What are the types of logical file?
Q.How primary file can be defined in RPG/400?Please write the senario with opcode specification?
The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...
What is the purpose of OVRDTA keyword ?
What is Sub-System?
when are the unique constraints executed?
when you are defining a flat file in your program in f specs which format will you specify?
A join logical file has how many record formats?
What is left outer join?
what is the maximum number of parameters allowed in rpg?
1.what operation cannot be used in conjunction with file coded as divice type disk? 2.Difference between INCLUDE AND COPY?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
RPG400 
