I am calling a stored procedure through the stored procedure stage from datastage.When i call stored procedure,i just fire the call statement and my datastage job finishes.My datastage Job will not wait until the stored procedure executes successfully.So then how i will come to know that procedure is executed successfully or its got failed.
So Is there any functionality in stored procedure stage,that it will wait until the procedure executes completely and returns any status.My stored procedure doen't return any value,but will value only IN parameter.
so can anybody guide about this.
Thanks,
prasad
stored procedure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Jul 18, 2007 12:23 am
- Location: Chennai
-
- Participant
- Posts: 38
- Joined: Wed Jul 18, 2007 12:23 am
- Location: Chennai
-
- Participant
- Posts: 38
- Joined: Wed Jul 18, 2007 12:23 am
- Location: Chennai
I asked my admin about the same and ha sdone some setttings and code working fine now.i will get the setup been done i will update about this.
In my stored procedure. iam just passing the Input parameter and it wont return any OUT parameter.So if the procedure fails due to any exceptions,then will my Datastage Job will also get aborted at the same with the same exception been trapped in datastage log.Or to have this functionality we need to have OUT parameter compulsorily.
Thanks,
prasad
In my stored procedure. iam just passing the Input parameter and it wont return any OUT parameter.So if the procedure fails due to any exceptions,then will my Datastage Job will also get aborted at the same with the same exception been trapped in datastage log.Or to have this functionality we need to have OUT parameter compulsorily.
Thanks,
prasad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Again, this falls under the heading of testing - you need to set up conditions (such as a faulty input argument) and verify what your DataStage does. You have already observed that it had been configured differently from Craig's - who knows what other differences may obtain?
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.
This is exactly the kind of sproc we typically use without issue. You don't need out parameters for error handling, as long as the sproc raises an error the job will notice. As noted, you should always test this kind of functionality (force it to fail) in order to verify proper functionality for yourself.prasad_chennai wrote:In my stored procedure. iam just passing the Input parameter and it wont return any OUT parameter.So if the procedure fails due to any exceptions,then will my Datastage Job will also get aborted at the same with the same exception been trapped in datastage log.Or to have this functionality we need to have OUT parameter compulsorily.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers