It can be achieved using the scroll able cursor along with the Relative opt

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 ?

Question Posted / saurabh

5 Answers
10999 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / saurabh

It can be achieved using the scroll able cursor along with the Relative option while updating the queue.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is host variable?

1109

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

1155

Explain the function done by data manager?

1329

How does db2 sample database connect?

1079

What is dbrm library?

1114

Explain in brief how does db2 determine what lock-size to use?

1085

What is a storage group (stogroup)?

1284

What is the use of runstats in db2?

1178

What is collection in db2 bind?

1059

What is a plan and package in db2?

1150

What is db2 stogroup?

1220

Before you give the explain statement, what are the prerogatives?

1079

What is bind and rebind in db2?

1186

How to execute stored procedures?

1175

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1138