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.

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,

---

Once you create a view, where would information about the view be stored?

1 Answers  

---

How many buffer pools are available in db2?

2 Answers  

---

How to see the structure of db2 table??

4 Answers   IBM,

---

What is a buffer pool?

2 Answers  

---

What is DCLGEN ?

3 Answers  

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

---

cursor with hold explain ?

1 Answers   Verizon,

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---