How to update more then one record using update?
- 5 Answers
- 10002 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 |
Define buffer pool.
Name the various locking levels available?
Q4. How will you get the count of record without using COUNT verb in query?
what is difference between Plan and Package
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
Explain correlated sub-queries.
Is db2 a database?
what's the best lock size that you could use when you create a tablespace?
How to update more then one record using update?
How to create backup table in db2?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
COBOL 
