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)

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

Answer / sreedhar reddy

One more..
It is not possible to update the data by using Join Logical files.
Thanks

what is *inzsr used for?

1 Answers   IBM,

---

Why we are not able to perform insert delete and update operation in Join logical file?

0 Answers   IBM,

---

Hi friends.. i want to be a IBM MainFrame Professional.. can any body tell me what is requirement for that... i m just BA, MA, and have simple diploma in Computers. what is pre-requisite.

3 Answers  

---

what is sflpag and sflsiz ?

2 Answers   IBM,

---

Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?

0 Answers  

---

I have SQLRPGLE program in which there are some update statements which executed correctly. there were no errors run time. Once the program gets over, the file was not updated with the new values. What might be the reason?

2 Answers  

---

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

1 Answers  

---

WHAT IS FERERENTIAL INTRIGRITY ?

0 Answers  

---

what is xfoot opcode ?

1 Answers   IBM,

---

What is the difference between regular logical file and join logical file?

1 Answers  

---

What is the use of OVRDBF ?

1 Answers  

---

does cl support arrays

1 Answers  

---