Declare a cursor like this in the application program exec sql Decl

I have 1000 rows in a db2 table.I want to update first 100
records,How do I do it?

Question Posted / ananth

4 Answers
15689 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / ananth

Declare a cursor like this in the application program
exec sql
Declare empcur cursor with hold for
select empno,empname from emp
for update of empsal
fetch first 100 rows only
end-exec.
this query will retrieve the first 100 rows and the cursor
is positiond at the first row in the resultent table.

Is This Answer Correct ?

23 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to find the number of rows in db2 tables?

1073

What are the bind parameters ibm db2?

1053

What is runstats and reorg in db2?

1304

What are the uses of db2 optimizer?

1296

Is db2 a programming language?

1049

Explain db2.

1037

What is db2 look?

1025

What is meant by dclgen?

1110

What is the syntax for seeing the columns and data types of a table in the db2 database?

1169

What is a system catalog table in db2?

1186

What is the physical storage length of time data type?

1129

How do I delete a table in db2?

1073

How do you eliminate duplicate values in db2?

1192

How do I connect my db2 database to ibm?

1051

What do you mean by commit and rollback?

1044