Hi !
I want to choose Replace Existing rows Update I see in View SQL the SQL generated with clause where in delete statement .
But how I can define the Where clause ?
I cant edit the SQL generated
Update action in ODBC stage
Moderators: chulett, rschirm, roy
Like all generated SQL, the 'where' clause is defined strictly by which fields you have marked as Keys.
Are you sure you need to use Replace Existing? It is different from Update in that it does a delete and insert for each record rather than just a simple update. It would typically (only?) be used if you are updating something like PK fields in a DBMS that didn't allow that.
Are you sure you need to use Replace Existing? It is different from Update in that it does a delete and insert for each record rather than just a simple update. It would typically (only?) be used if you are updating something like PK fields in a DBMS that didn't allow that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi,
to add on what craig said.
you can also have some controll if you'll use a user defined syntax.
IHTH,
to add on what craig said.
you can also have some controll if you'll use a user defined syntax.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org