What is the use of Stored Procedure Stage and in what situation we have to use ? Adn what is the advantages of this stage to use in a job ?
Thanks guys
Stored Procedure Stage
Moderators: chulett, rschirm, roy
Thanks
Alright Brow, I just become a member of this site, just 45 minutes ago. Good to know about this site Buddy...narasimha wrote:It is used to execute Stored Procedures.
Izack, please search before posting, these questions are already addressed here.
Thanks guys
Then I suggest you go through this post.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Re: Stored Procedure Stage
IMHO - none and very few. Use it if you have to.Izack wrote:In what situation we have to use ? And what is the advantages of this stage to use in a job?
-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:
Re: Stored Procedure Stage
To invoke a stored procedure (d'oh!) for every row processed.Izack wrote:What is the use of Stored Procedure Stage ?
You can also invoke stored procedures from the Enterprise ODBC stage, but with more restrictions.
Last edited by ray.wurlod on Wed Jan 31, 2007 3:41 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Stored Procedure Stage
I cant stop laughing now.ray.wurlod wrote:To invoke a stored procedure (d'oh!) for every row processed.Izack wrote:What is the use of Stored Procedure Stage ?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.