ORAOCI Bulk load upsert?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Hongqing
Participant
Posts: 9
Joined: Fri Aug 20, 2004 5:53 pm
Location: Pleasanton, CA

ORAOCI Bulk load upsert?

Post by Hongqing »

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?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply