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
What is a page in db2?
How do I start db2 in windows?
i want to maintain uniqueness on pdf without make lf??????????
What is difference between rollback and commit?
What is precompiler in db2?
What is the use of with ur in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What's The Percentage Free Space ?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the role of union all and union
What is syscat in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Which command is used to connect to a database in DB2 ? Give the Syntax.
Why db2 is called db2?