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 multijoin logical file? what are the keywords available in joinlogical file? what are the mandatary keywords for joinlogical file? explai the keywords?

2 Answers   HCL,

---

WHAT IS AS/400 SYNORIO?

0 Answers   CTS, EDS,

---

I have to execute 12000 CL Commands one by one.. So, I have created a file called COMMAND. This file has only 1 field called STRING. This file had 12000 records, and all these records are CL Commands (ex: CALL PGM(PGM1)), etc) I have written a CL which will read all the record and do sbmjob.. But it is not working... Plz help me to exexute all these 12000 commands..

2 Answers   ISE,

---

What is the purpose of the following FORDHDR1 CF E WORKSTN $2SFN SFILE FMT2

1 Answers  

---

Can be OVRDBF command mentioned after OPNQRYF command in CL?

1 Answers  

---

---

which cl command can be used at program execution to redirect the file named in an rpg program?

0 Answers   IBM,

---

What is Job, What are the attributes of a Job?

1 Answers  

---

Define each of the following operation codes a, b, c, d, e

1 Answers  

---

Is it necessary to define all formats ? Which are mandatory and which are Optional ?

1 Answers  

---

in conjunction with which statements can orxx and andxx conditions be used ?

1 Answers   IBM,

---

What is the difference between Interactive & Batch Job?

1 Answers  

---

what is *iso date format?

0 Answers   IBM,

---