I have 1000 rows in a db2 table.I want to update first 100
records,How do I do it?
Answer Posted / rama krishna.
UPDATE DB2 SET COL=VAR/EXPR WHERE ROWNUM<=1OO;
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Which components manage deadlocks in db2?
Which isolation level provides highest data integrity?
Explain about mirror activator disk mirroring?
Mention the location where the output received from explain statement is stored.
What is the use of with ur in db2?
Can you use max on a char column?
Explain about open switch business continuity software?
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 ?...
What is view db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Why db2 is called db2?
What is a db2 package?
Who uses db2?
Can we update view in db2?
What is difference between alias and synonym in db2?