Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 15367 Views
- ANZ, I also Faced
- E-Mail Answers
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 the difference between non-join logical files and join logical files?
how can you detect and handle a record lock situation?
How many MONMSG commands can declare in a CL program?
Which command we can use to update a physical file using c.l pgm?
what is subfile?
What is library list ?
what does the opcode free do?
Difference between NOPASS & OMIT?
what is sessional error or divice error in rpg IV?..when will it happens...Give few examples?
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 are the different types of keywords in display files?
what do we can do with the embedded sql statements?
RPG400 
