Can we actually use an Oracle "MERGE" sql inside an Oracle Enterprise stage? If not, what is the most efficient way to accomplish this function in Datastage? Ie, using sqlldr(Load), upsert, etc?
Thank you.
Using Oracle Merge inside Oracle Enterprise stage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
Via "user defined SQL" you can execute any SQL that is legal in the database, provided that the correct number of columns is bound to the query.
Via "user defined SQL" you can execute any SQL that is legal in the database, provided that the correct number of columns is bound to the query.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
We use this a lot. A dummy link on the left side (either from the row generator or "select dummy from dual") which triggers the right side declared as "user defined update only" which contains the merge statement. The downside is you don't get to see number of rows processed.
Ray, is there any better solution to this?
Ray, is there any better solution to this?