Is stored procedure stage recommended in DSEE

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
Lali_swam
Participant
Posts: 39
Joined: Thu May 05, 2005 3:39 am
Location: Bangalore
Contact:

Is stored procedure stage recommended in DSEE

Post by Lali_swam »

Hi,
I read in the Install guide that DSEE does not recommend SP using ODBC. But now that there is a stored procedure stage, is this recommended? Does this stage return the correct result set when invoked.
Is it wise to use a stored procedure stage or do we have to substitute that.
All help/info is appreciated.

Thanks,
Lalitha
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Surely, since this is a vendor recommendation, you should ask this question of the vendor (through your support provider of course).
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