File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes DB2 Update Sql based on calculation Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "DB2 Update Sql based on calculation " Watch "DB2 Update Sql based on calculation " New topic
Author

DB2 Update Sql based on calculation

Amanda Fu
Ranch Hand

Joined: Jul 17, 2003
Posts: 31
posted
0
Quote
I have 3 tables with fields,

table1.col1,
table2.col2,
table3.col3,

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: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: DB2 Update Sql based on calculation
 
Similar Threads
data migration from one table to the other
Projection from inner join
Simple sql
Question of using SqlResultSetMapping
Improving performance of view