How to update a table there is a expression in the sql
Posted: Wed Feb 08, 2012 3:40 am
when I want to update a column and set the column_a = column_a * percent in a table in a stage, also in the input link there are two columns and named to key_1 and percent.
so the sql i want to write to like :
update table_name set column_a = column_a * percent where key_1=? ;
but when i run the job there is a error :
Task_one_point_two..Employee: [IBM][CLI Driver][DB2/AIX64] SQL0206N "percent" is not valid in the context where it is used. SQLSTATE=42703
who can help me out thanks.
so the sql i want to write to like :
update table_name set column_a = column_a * percent where key_1=? ;
but when i run the job there is a error :
Task_one_point_two..Employee: [IBM][CLI Driver][DB2/AIX64] SQL0206N "percent" is not valid in the context where it is used. SQLSTATE=42703
who can help me out thanks.