Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 5 Answers
- 10842 Views
- IBM, I also Faced
- E-Mail Answers
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 db2 instance?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do I delete a table in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Define db2 and its databases?
Explain in detail about buffer manager and its functionalities?
Explain dclgen.
What is bind in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
Define sqlca.
Mention some fields that are a part of sqlca.
Explain correlated sub-queries.
What is view db2?
What is the physical storage length of timestamp data type?
