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 |
Can be OVRDBF command mentioned after OPNQRYF command in CL?
how does the runqry show the output?
What is GDA?
explain the difference between defining subfile and message-subfile?
what is the maximum number of parameters allowed in rpg?
What is an Array Data Structure?
what is the use of jdftval in join logical file?
how will you search an array?
how do you specify the number of records to roll in a subfile ?
What is class of service ?
what is the length of a variable in rpg?
what is the main use of OPNQRYF ?? in that query why we can use OVERDBF and in that OVERDBY why should we use SHARE(*YES)