about control break logic to figure out DELETE then INSERT

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ranga1970
Participant
Posts: 141
Joined: Thu Nov 04, 2004 3:29 pm
Location: Hyderabad

about control break logic to figure out DELETE then INSERT

Post by ranga1970 »

Hi,
I am using ora9 to load my data to oracle, how to incorporate control break logic to figure out DELETE then INSERT

thanks
RRCHINTALA
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

I cannot for the life of me figure out why you would want to do this. Can you please explain what your problem is, maybe we can give you a better solution.

Your answer to your posed question, unfortunately, is to load whatever data you have created into a table, and then kick off a stored procedure to actually manipulate that data into your tables.

I think there's a chance we can guide you to a better solution.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply