Answer Posted / siri

suppose we want update ename in emp table using cursor....

declare crsorname cursor for
select * from emp
where dept='d005'
for update of ename....


upate emp
set ename=:ename
where current of cursor

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2094

---

What is database reorganization?

1185

---

How do I add a column to a table in db2?

1162

---

What is netezza database?

1082

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11746

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2162

---

What is reorg and runstats in db2?

1263

---

What is cascading rollback?

1283

---

what is the sqlcode -501

13314

---

What is the role of union all and union

1195

---

What do you mean by rollback?

1039

---

What do you mean by between and in? Is between inclusive of specified range values?

1142

---

What is explain in db2?

1080

---

What is the difference between plan and package in db2?

1176

---

How do I import data from excel to db2?

1132

---