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
ORCHESTRATE
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: