Should we use store Proc in DataStage.

[anshumangupta1206]

Hi All,
I have to call store Proc in Datastage. But I heart from many experts that we should not use it. Can somebody give me the reasons for the same.

Thanks.

[ArndW]

I'm curious as to what the experts are saying about the use of stored procedures. There are some cases where a stored procedure is the only way to get things done and many where their use is going to slow jobs down.

[chulett]

In all the years I've been doing this, I have yet to see a situation where I had to use a Stored Procedure. Maybe that's unusual, don't know. Looks like our foray into SOA land may require one real soon, however.

Unless you are doing something that absolutely requires it, I would tend to avoid them...

[ray.wurlod]

Welcome aboard. :D

What "experts"?

[anshumangupta1206]

Thanks for all suggestions.
May I explain my situation then you all would be more tend to give exact views. Actually our application is based on VB code and the interfaces we are carrying on DataStage. In VB code our convention is to update table through store proc. So, shd I use the same convention in DataStage.

[kumar_s]

Hi,

Just give a try to search this forum for the topic "Stored Procedure".
I got 300+ topics. You can call stored procdures from your ODBC stage.
Since you are dealing with the database directly from DataStage, it should be possible.
Also let us know, what you trying to achieve thorough procedures?

-Kumar

[raj_konig]

Hi,

No need to follow the same convention. you can easily accomplish your task by the normal way instead of using a stored procedure.

As far as my knowledge is concerned, there is no problem in usign the stored procedures.

rajesh