Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi All
I have two task to do.
1. I wanna update into existing table in oracle, is there any option to do that ?
2. Then I wanna insert into existing table in oracle, I saw the append instead of overwrite option but how to give the existing table in output ?
Please guide/Suggest the way
Thanks in advance
Hi @Renga3037
UPSERT operations are not graphically supported in DSS, however, you can still carry out these operations if you use a SQL recipe script option, see here for some info on how these work.
Good luck!
For task 1 you can use an SQL recipe script type with UPDATE inside.
For task 2 you can use a normal SQL recipe which will compute records and append new records if you have selected Append new records from the Input/Output tab of the recipe.
Or
You could do both in one go using an SQL recipe script type with UPSERT inside.