1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / brooks

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


Please Help Members By Posting Answers For Below Questions

What is dbrm? What it contains? When it will be created?

591

What is rct?

751

What is the use of value function?

622

What is the purpose of rollback and commit?

593

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3116




What is the use of db2 optimizer?

608

Give the name of some fields form sqlca.

611

What is a bind card?

679

What is bufferpool in db2?

576

Which isolation level provides highest data integrity?

595

What is cobol db2?

568

Explain the benefits you can get from mainframe connect?

520

What is null value in db2?

563

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

706

What is ibm db2 client?

517