Interested to Buy Any Domain ? << Click Here >> for more details...
How to update more then one record using update?
- 5 Answers
- 11294 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pratap singh
For this concern you can use or oprator along with where
clause, Example
WHERE DEPT_ID='D110' OR 'D001' OR 'D105'
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sivakumar sekharannair
update query without "where" command will update multiple
rows in the table;
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / selvam a
Update a table using a symbolic cursor:
UPDATE WHERE CURRENT OF limits the scope of DB2 updates to
one row at a time, specifically the row your cursor is
positioned on.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guna
UPDATE table1 set columnname = (SELECT columnname from
table2 where some condition)
You can also use EXISTS instead of '=' for updating
| Is This Answer Correct ? | 0 Yes | 2 No |
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What is filter factor?
What is schema in db2?
What is host variable?
Explain db2.
Do we need cursor for Count(*)?
Explain how can you do the explain of a dynamic sql statement?
Can any one tell me about Restart logic in DB2.
Where would you find information about the type of database authority held by the user?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
explain about index with examples
What are the prerogatives?
COBOL 
