I have 1000 rows in a db2 table.I want to update first 100
records,How do I do it?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rama krishna.
UPDATE DB2 SET COL=VAR/EXPR WHERE ROWNUM<=1OO;
Is This Answer Correct ? | 1 Yes | 6 No |
Answer / brooks
is there identity column in this table, for example, if
there is a column indexnum int(supposed start from 1), you
can use the Update Table Set XXX=XXX where indexnum < 101
Is This Answer Correct ? | 0 Yes | 6 No |
Which component is responsible for db2 startup and shutdown?
What are column-name qualifiers used?
What is the role of data manager in the db2 database?
What is meant by explain?
what is difference between random and sequence file access
How many types of page locks can be held in db2?
What is performance tuning db2?
What is -904 sql code? How to resolve it?
explain about index with examples
what is utility for parm lib
What is a trigger in the db2 database?
What can the Locate option of the Repair Utility accomplish?