Answer / s

Subselect is a SELECT in the WHERE clause, providing values
to the outer select to get the qualifying rows. You can use
up to 225 subselects in a single SQL which are called
nested selects or nested subselects.

Why cursor is used in db2?

0 Answers  

---

What are the various locking levels available?

3 Answers  

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

What is the use of runstats in db2?

0 Answers  

---

What is pagespace?

1 Answers  

---

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

What is rebind in db2?

0 Answers  

---

What is a DB2 bind?

1 Answers   Logica CMG,

---

What is null indicator in db2?

0 Answers  

---