Answer / pratap singh

For this concern you can use or oprator along with where
clause, Example

WHERE DEPT_ID='D110' OR 'D001' OR 'D105'

Answer / sivakumar sekharannair

update query without "where" command will update multiple
rows in the table;

Answer / k

Don't give where command in update query

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.

Answer / guna

UPDATE table1 set columnname = (SELECT columnname from
table2 where some condition)

You can also use EXISTS instead of '=' for updating

When do you specify the isolation level?

0 Answers  

what is the soft code for deadlock ?

2 Answers   Logica CMG,

What is db2 command?

0 Answers  

What else is there in the PLAN apart from the access path?

1 Answers  

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

What is difference between rollback and commit?

0 Answers  

How Plan is created while executing the query using SPUFI?

3 Answers  

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,