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

difference between sflrcdnbr and sflnxtchg?

0 Answers   IBM,

---

When would the ALL keyword be used?

1 Answers  

---

How to read 2 positions at a time in a data area? I have created a data area of length and i have to read the values of the data area like 91-92,93-94 at a time up till 100

3 Answers  

---

What is binder language ?

0 Answers  

---

Can you use multi format LF in CL program?

2 Answers  

---

what is overlay?

0 Answers   IBM,

---

How can we read file using curser? how to define a curser?

0 Answers  

---

I have a display file with mandatory fields. Is there anyway that i can highlight those fields to bring attention to the user? The same behavior that AS400 makes when we attempt to execute a command without completing all the required parameters. Note: I have used DSPATR(HI) or DPSATR(RI) and they have different behaviors. Thanks.

2 Answers  

---

What are the different definition levels in Data Description Specifications?

1 Answers  

---

What is the Function of PDM?

1 Answers  

---

In which specification Data Structures can be defined?

1 Answers  

---

What is the symbol used for defining a new field in SDA?

1 Answers  

---