How to update more then one record using update?
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 |
Could anyone clearly explain the diference between sub query and correlated sub query?
What is catalog database in db2?
What are the various data types available in db2?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What are db2 objects?
What is the role of union all and union
Can we use select * statement in cobol program without giving field names ???
Can a array declared with an index be displayed(readable format) in spool?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).