In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)
- 9 Answers
- 13421 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sherman_li
Actually, you don't need to delete this data, just move
foward the remaining data(from 8th to 100th), for example,
8th -> 7th
9th -> 8th
...
100th -> 99th
hope this is what you want
| Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
How do I delete a table in db2?
What is a plan and package in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Define buffer pool.
Discuss about db2 bind?
Mention the different locking levels that are available in db2.
What are the bind parameters ibm db2?
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 ?...
How can you find out the # of rows updated after an update statement?
What is the role of the data page in the db2 database?
Why cursor is used in db2?
What are iseries servers?
What is commit in db2?
What does sqlcabc has?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
