ORCHESTRATE

[developeretl]

Hi Im trying to update the table in the database.
From source i have one column and i need to update the target database based on the update statement. correct me if my statement is wrong.

update table
set col3=1234
col1=orchestrate.col1
col2=orchestrate.col2
in col3('1','2')

ERROR :DB2_Connector_1: Error when checking operator: Could not find input field "col1".
Error when checking operator: Could not find input field "col2".

Can you help me with this

[dsuser_cai]

I assueme DB2 as database.
I dont see a "Where" Clause in your statement.

[keshav0307]

update table
set col3=1234
col1=orchestrate.col1
col2=orchestrate.col2
in col3('1','2')

is this the actual query?
should be something like :

update table <Table-name>
set col3=1234
WHERE col1=orchestrate.col1
AND col2=orchestrate.col2

etc.

[ray.wurlod]

What are the columns named in your DataStage job, and which (if any) of these are identified as "Key"?