Answer / s

Inner Join return only matching rows whereas Outer Join
returns matching rows from both tables and unmatched rows
from either of the table depending on the join.
RIGHT outer Join returns matching rows and unmatched rows
from the right table.
LEFT outer join returns matching rows and unmatched rows
from the left table.

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

What is explain plan in db2?

0 Answers  

---

When do you specify the isolation level?

0 Answers  

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

What is the use of db2?

0 Answers  

---

Explain dclgen.

0 Answers  

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---