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.

How to write a password mask program in as400? like the password which i type should be displayed as '*****' r ###### which the user wishes to dispaly if u could help me with url r the solution in written code this will help me

21 Answers   Accenture, SNS,

---

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

1 Answers  

---

What is array in as400? What are the types of array?

1 Answers  

---

Can anybody know what is Pick/Basic? Is it a programming language? can it be used in AS400 machine?

2 Answers  

---

what are the limitations of cl (compare to rpg) ?

2 Answers   IBM,

---

what are the necessary keywords for the join logical file?

2 Answers   IBM,

---

some special characters I key in my html source members show different on my web pages. Why? How can I solve this?

1 Answers   IBM,

---

what is default data type for the fields(sub fields) defined in data structures in rpg?

2 Answers   IBM,

---

What is the use of E specification in RPG?

1 Answers  

---

can error messages as a result of a comp, range or values keyword be overridden?

2 Answers   IBM,

---

all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?

1 Answers  

---

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

1 Answers  

---