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
15887 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

What is db2 look?

1078

What is db2 command?

1091

Is db2 a database?

1028

Mention data types used in db2 ?

1201

Explain what are the various isolation levels possible?

1098

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4372

What is consistency token in db2?

1195

What is null value in db2?

1077

what are bind concepts in db2 cobol?

1138

Define db2 and its databases?

1113

What r the comman abends in db2, jcl and cobol???????

2309

What is alias in db2?

1109

What os does db2 run on?

1048

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3010

What is dclgen (declaration generator)?

1117