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 a join logical file?

0 Answers   IBM,

---

Q. Soppose one job is running in a batch mode for long time now i want to kill(end)this batch job.How you will achive this?

4 Answers   IBM,

---

what is library?

1 Answers   IBM,

---

In which specification can a report layout be defined ?

1 Answers  

---

how to see the error messages for each command in cl?

2 Answers   CGI,

---

what is the function of rlu ?

1 Answers   IBM,

---

what is the function of cpysplf command?

1 Answers   IBM,

---

How can I automate sftp commands(ls & get) in CL program.. If I want to write two scripts one for each command... can u plz tell where the script should be written? & what will be the content of each scripts?

1 Answers  

---

what are the different types of data areas?

1 Answers   IBM,

---

Can be OVRDBF command mentioned after OPNQRYF command in CL?

1 Answers  

---

What is the purpose of PR and PI in calling program and called program? in Called program PR is compulsory?

1 Answers   HCL,

---

what is the disadvantage of using global variable?

0 Answers   IBM,

---