Answer / guest

You add the keyword "WITHHOLD" to the declare statement of
the cursor

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  

---

What is dbrm? What it contains?

0 Answers  

---

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

---

---

select 100 records from million records ?

2 Answers   Verizon,

---

What is db2 and what is the use of db2 optimizer?

0 Answers  

---

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,

---

What is the use of commit in db2?

0 Answers  

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

What does the REORG Utility do?

2 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---