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
- 15018 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 use purpose of CRTCMD?
what is the purpose of DMPCLPGM IN CL?
What is a Join Logical File, Can it be used for Update ?
What is the use of Data Queues?
writing an sql statement from selecting records from two files using single statement and nested select statement.
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 is service program?
How can a data area be locked after being updated?
Is it possible to add an keyfield or field to an Physical file without changing its file identifier. Example : - Say I have an existing physical file which is being used in 5 programs. Now I want to add an additional Keyfield or an field to it and I don't want to recompile the programs.
how to create physical file
what is data structure?how many types of data structers?
i have two pfs it contains "Status" fields in the same name "status in both the pf's...But i used the same name in display file...when i enter a status thru disp file it willbe added to pf1...so i want to rename "Staus " field in pf2 through program...............wat will do..give coding?
RPG400 
