Interested to Buy Any Domain ? << Click Here >> for more details...
I have 1000 rows in a db2 table.I want to update first 100
records,How do I do it?
- 4 Answers
- 15688 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 to check last update on table in db2?
Explain packages.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How to access db2 tables in mainframe?
Mention some fields that are a part of sqlca.
How can you quickly find out the # of rows updated after an update statement?
How to fetch the last row from the table in SQL (db2)?
What is the reason behind not using select * in embedded sql programs?
Define buffer pool.
what is diffrence b/w file-aid tool and file-aid utility???
What does db2 blu stand for?
How do I copy a table in db2?
How to connect to db2 database from windows command line?
How can the duplicate values be eliminated from db2 select?
Which component is responsible for processing sql statements and selecting access paths?
