Pass all records of Input Link as array parameter in STP

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
apraman
Participant
Posts: 47
Joined: Mon Sep 12, 2005 5:26 am

Pass all records of Input Link as array parameter in STP

Post by apraman »

Hi,
I have a Oracle stored procedure which can take tables as in parameter. does a BULK insert, it does some other process too.

My main objective is not to call stored procedure for each row of Input link. I want to pass all values of the input link as array.

Is there any way to achieve it?
Arun
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
The most simple way is to load a temp table and then invoke the SP nce to do the work.

If there is no objection/reason not to implement all logic in DS I prefer a DS solution over a SP one.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply