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
- 10686 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
If I have a view which is a join of two or more tables, can this view be updateable?
What is the use of commit in db2?
What are the contents of dclgen?
What is null value in db2?
What are concurrency issues?
What is the difference between cursor stability and repeatable read isolation levels?
Explain about open switch business continuity software?
What is the maximum number of columns in a db2 table?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Is the primary key a clustered index?
How does cobol compile db2 program?
How can you quickly find out the # of rows updated after an update statement?
How does coalesce work?
When do you specify the isolation level?
What is universal database?
