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 message file?
different type of cursor?
How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz
What is Multi-format logical file?
Want to know related Interview questions and answers for seniors
maximum number of subfiles that can defined in a rpg program for one display file is?
What are the different types of specification available in RPG/400 ?
What is the maximum number of key fields allowed defining in a physical file?
What is source physical file?
What is the difference between Array and Table?
what is the command to rtrieve system date? options:1.rtvsysval 2.rtvjoba 3.rtvjobd 4.both a and b
what does exfmt does?