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
- 13734 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 |
how to change job priority when it is running in sub system ?
how a varible can be passed to a subfile...accnt1 contain data in a data area..ie Daccnt1 uds,Daccnt2 3 overlay(accnt1:1), DNo 4 overlay(accnt1:4)..we want to transfer this dataarea value from acnt0001 to a subfile..that means to enter each record we have to incriment account no,, i normal window we can do move accnt1 account_no eval account_no=accnt1 eval no=no+1 exfmt usr_account how it possible with Subfile????????.Please do answer? (Thank you for all your answers dear friends!!)
What Does Lokup Does In Tables & Arrays?
what is elastic and non elastic subrile?
How I can read and display three fields in the record format DSPFM1 of the display file,while one field(using in one file) is NAME which is Key field in field reference file and another two fields are AGE and ROLL NO are using another file. Please send me coding part.
What Is The Difference Between Goto & Exsr?
what is message file?
what is the maximum number of fields under a record format of physical file?
What is the necessary keyword used in a physical file to refer field definitions from the field reference file?
what are the limitations of cl (compare to rpg) ?
Can fields be concatenated INa logical file level?
what do we can do with the embedded sql statements?
RPG400 
