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
- 14391 Views
- ANZ, I also Faced
- E-Mail Answers
Answer Posted / s. kumar
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 |
Post New Answer View All Answers
What Is Default Data Type (if You Define Decimals '0') In Physical File?
can you specify a display file to be used in the following modes input,output, or combined modes ?
what are the different types of variables available in cl?
writing an sql statement from selecting records from two files using single statement and nested select statement.
Using %check we are checking monika in mona what is output? What is %SCAN?
What is a query can be displayed without saving it?
what is logical file?
What are the types of data structure in as400?
How to add 99 menu (page down) option in menu creation..
Can you summarize the steps I have to go through in writing my first cgi?
Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?
an access path may be in which sequence?
can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com
what are members?
what if my system I runs with system value qccsid 65535?
