Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
JDBC and Relational Databases
DB2 Update Sql based on calculation
posted 11 years ago
I have 3 tables with fields,
Now I need to update table3.col3 with the value based on calculation like (table3.col3 * table1.col1 / table2.col2). How to do this use a update clause?
Any response will be appriciated.
[ September 21, 2004: Message edited by: Bear Bibeault ]
I agree. Here's the link:
Question of using SqlResultSetMapping
Projection from inner join
data migration from one table to the other
Improving performance of view