Hi Team,
I am updating bunch of records in the target but I want to use my own sql to update records using LIKE operator.
Can any one help with the syntax.
SKU_ID is the key and the below syntax doesnt work if I give in the target stage connector/enterprise stage.
UPDATE SKU SET SECONDARY_DESC=:SECONDARY_DESC,COLOR=:COLOR WHERE SKU_ID LIKE:SKU_ID%.
Target stage oracle
Moderators: chulett, rschirm, roy
Try
Code: Select all
UPDATE SKU SET SECONDARY_DESC=:SECONDARY_DESC,COLOR=:COLOR WHERE SKU_ID LIKE '%'||:SKU_ID||'%'
Is this actually a Server job question as marked?
You'll need the SKU_ID enclosed by percent signs and single quotes for the LIKE operator, so probably more like this. Have no way to test it, however.
You'll need the SKU_ID enclosed by percent signs and single quotes for the LIKE operator, so probably more like this. Have no way to test it, however.
Code: Select all
UPDATE SKU SET SECONDARY_DESC=:SECONDARY_DESC,COLOR=:COLOR WHERE SKU_ID LIKE '''%'||:SKU_ID||'%'''
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers