Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answers were Sorted based on User's Feedback



1.What is the difference between regular join logical file and non join logical file? 2.what are ..

Answer / 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

1.What is the difference between regular join logical file and non join logical file? 2.what are ..

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

1.What is the difference between regular join logical file and non join logical file? 2.what are ..

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

Post New Answer

More IBM AS400 AllOther Interview Questions

what is elastic and non elastic subrile?

0 Answers   IBM,


How to reverse the string in rpg

0 Answers  


when are the unique constraints executed?

0 Answers   IBM,


what is procedure prototype and procedure interface.

0 Answers   IBM,


Hi, can you plz tell me ...syntax for GET command in FTP & SFTP is same or different???

3 Answers  


How do you set the keywords SFLSIZ and SFLPAG if you want the subfile to dynamically expand?

1 Answers  


What is the difference between Interactive & Batch Job?

1 Answers  


How can the user implicitly open and close the files in RPG program ?

2 Answers  


can a single screen format occupy a screen area above and below a subfile format ?

1 Answers   IBM,


For AS/400 Freshers good website is

3 Answers   HCL, HP,


what is the command to know how many lf are related to a pf?

1 Answers   IBM,


what is externally described file ?

1 Answers   IBM,


Categories