Interested to Buy Any Domain ? << Click Here >> for more details...
How to update more then one record using update?
- 5 Answers
- 11749 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 |
max number of columns in a db2 table?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
Explain about rct.
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the purpose of rollback and commit?
Explain about cursor stability?
How to handle null values in db2
Define check constraint.
What is SPUFI?
Give some example of statistics collected during RUNSTATS?
how can u understand the end of the table ?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
COBOL 
