suppose in my table 10 rows are there , i want to update odd
rows salary as 90000 ? how u do it ? any one help me ? what
do we use here cursor-fetch or normal sql ?
Answer Posted / pandu
Hi Krishna, Actually your answer is ok but i have a small
doubt "he want to update odd rows salary as 9000" but in ur
answer i didn't find the odd rows.how will you divide that
table in odd rows and even rows? kindly tell me.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Define predicate?
What are the contents of dclgen?
What is db2 plan table?
Can we delete records from view?
What are catalog tables in db2?
How to find the number of rows in db2 tables?
What is the purpose of rollback and commit?
Why do chiropractors use drop table?
Are view updateable?
What parameters are used to control the free space in DB2?
What is null value in db2?
What is the maximum size of varchar data type in db2?
What is an instance database?
Name the lockable units in DB2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?