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.
Should we use store Proc in DataStage.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Tue Jan 24, 2006 9:11 am
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...
Unless you are doing something that absolutely requires it, I would tend to avoid them...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 42
- Joined: Tue Jan 24, 2006 9:11 am
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.
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.
wed
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
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