Answer / sanjudharan

UNION : eliminates duplicates

UNION ALL: retains duplicates

Both these are used to combine the results of different
SELECT statements.

Suppose I have five SQL SELECT statements connected by
UNION/UNION ALL, how many times should I specify UNION to
eliminate the duplicate rows? -

Once.

Answer / sandeep

Correct answer..

What is alias in db2?

0 Answers  

---

What is isolation level in db2?

0 Answers  

---

What is read-only cursor?

1 Answers  

---

Write a query to retrive partial string.

2 Answers  

---

What does CURRENTDATA option in bind indicate

1 Answers   IBM,

---

How to access db2 tables in mainframe?

0 Answers  

---

How is a typical db2 batch pgm executed?

0 Answers  

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

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,

---

What is node in db2?

0 Answers  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---