I have 1000 rows in a db2 table.I want to update first 100
records,How do I do it?
- 4 Answers
- 13723 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you select a row using indexes in db2?
What is the purpose of using commit?
What is the connection string to connect to the DB2 Database ?
Explain various types of locks in db2?
What do you mean by cursor?
what is diffrence b/w file-aid tool and file-aid utility???
What is dbrm in db2 database?
Which component is used to execute the sql statements?
How do I create a view in db2?
Explain about dbrm.
How will you return the number of records in table?
How is the value function used?
Why do we bind in db2?
What is the result of open cursor statement?
What is the role of union all and union
