Answer / syam

This is using in SQL
A left outer join will return all the rows that an inner
join returns plus one row for each of the other rows in the
first table that did not have a match in the second table.

Answer / kapil kumar

We can also use this concept in as400
JDFTVAL is a file level keyword used in Join Logical File.
It also act as left outer join.

What is an Array Data Structure?

1 Answers  

---

What is the use of Header Specification in RPG/400?

1 Answers  

---

Can be OVRDBF command mentioned after OPNQRYF command in CL?

1 Answers  

---

What is the difference between externally described file and program described file?

1 Answers  

---

what is the function of rlu ?

1 Answers   IBM,

---

---

What is the purpose of the following? A CSRLOC (F1ROW F1COL)

1 Answers  

---

How to genarate the reports?

1 Answers  

---

what is the purpose of dynslt keyword?

1 Answers   IBM,

---

what is the maximum number of record formats in dspf?

1 Answers   IBM,

---

In which specification Data Structures can be defined?

1 Answers  

---

is it possible to create a physical file without dds?

1 Answers   IBM,

---

I am a fresher. I got project on AS 400. Can any body suggest the best book for learning of it.

1 Answers  

---