how to update table set a=c where a<c in DB2 stage
Posted: Mon Sep 10, 2007 12:30 am
Hi
To update table set col1 = variable1 where col1 < variable1, I get the value1 in a transform stage and out put to a DB2 stage. In db2 stage the sql looks like: update table_name set col1 = ? where a < ?; The problem is in transform stage, I can only map value1 to col1 once, ie, only one ? has been asigned value. If value1 is a job parameter, there is no problem to have update table_name set col1 = #parameter# where col1 < #parameter#. With value1 from inside the job, how can I achive the above updating table?
Thanks in advance for suggestions/sulotions.
To update table set col1 = variable1 where col1 < variable1, I get the value1 in a transform stage and out put to a DB2 stage. In db2 stage the sql looks like: update table_name set col1 = ? where a < ?; The problem is in transform stage, I can only map value1 to col1 once, ie, only one ? has been asigned value. If value1 is a job parameter, there is no problem to have update table_name set col1 = #parameter# where col1 < #parameter#. With value1 from inside the job, how can I achive the above updating table?
Thanks in advance for suggestions/sulotions.