Target stage oracle

[karry450]

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%.

[rkashyap]

Try

Code: Select all

UPDATE SKU SET SECONDARY_DESC=:SECONDARY_DESC,COLOR=:COLOR WHERE SKU_ID LIKE '%'||:SKU_ID||'%'

[chulett]

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.

Code: Select all

UPDATE SKU SET SECONDARY_DESC=:SECONDARY_DESC,COLOR=:COLOR WHERE SKU_ID LIKE '''%'||:SKU_ID||'%'''

[rkashyap]

On DataStage 9.12, LIKE '%'||:SKU_ID||'%' works ok.

[chulett]

Interesting... thanks for checking. Seems to me that DataStage must be supplying the wrapper quotes otherwise Oracle would be barfing.