ORAOCI Bulk load upsert?
Moderators: chulett, rschirm, roy
ORAOCI Bulk load upsert?
We are going to use the ORAOCI bulk load to load the sequencial files. In the file there will be some records to be inserted and some records to be updated. We will provide the flag for insert or update in the input file if needed. My question is: for the ORAOCI stage in the DataStage, is it doing insert only or is it doing upsert? We would like to use the upsert. Is it possible to do upsert with DataStage and how?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Take a look at the stage properties (Write Method of Load property) and/or the script file that is produced.
Details are in the Parallel Job Developer's Guide in Chapter 12.
Details are in the Parallel Job Developer's Guide in Chapter 12.
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.