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
- 15015 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 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!!)
How can I automate sftp commands(ls & get) in CL program.. If I want to write two scripts one for each command... can u plz tell where the script should be written? & what will be the content of each scripts?
can you have multiple key lists for a single file ?
What is the purpose of the following C/COPY QRPGSRC, ORDERR
How to avoid using indicators in ile ?
What is Job description?
can a indexed file be accessed in arrival sequence in rpg program?
Suppose we have field reference file we were any changes that corresponding Physical file then what will Happen in field reference file??
What is the use of OVRPRTF ?
Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?
What is the maximum number of subfiles that can be specified in a display file?
which are the string manipulation opcodes?
RPG400 
