1.What is the difference between regular join logical file
and non join logical file?
2.what are the nessasary keywords for non join logical file
Answers were Sorted based on User's Feedback
Answer1:
More than one Database file can be joined by different ways
like..
1)Inner join or Join Logical file
2)Left outer Loin
3)Right outer Join
4)Self join
These all are join logical file.
Non Join Logical file means Simple Logical file i.e Only
one PF file.
Answer2:
PFILE is the necessary keyword for non
join logical file.
R Rec-For PFILE(PF name)
| Is This Answer Correct ? | 20 Yes | 0 No |
Answer / rahul gupta
There is one more difference in both and that is :
We can insert data into PF using Non Join logical files but
we can not insert data using Join logical files
| Is This Answer Correct ? | 23 Yes | 3 No |
Answer / sreedhar reddy
One more..
It is not possible to update the data by using Join Logical files.
Thanks
| Is This Answer Correct ? | 11 Yes | 0 No |
what is elastic and non elastic subrile?
How to reverse the string in rpg
when are the unique constraints executed?
what is procedure prototype and procedure interface.
Hi, can you plz tell me ...syntax for GET command in FTP & SFTP is same or different???
How do you set the keywords SFLSIZ and SFLPAG if you want the subfile to dynamically expand?
What is the difference between Interactive & Batch Job?
How can the user implicitly open and close the files in RPG program ?
can a single screen format occupy a screen area above and below a subfile format ?
For AS/400 Freshers good website is
what is the command to know how many lf are related to a pf?
what is externally described file ?