How to call stored procedure in transformer stage
Moderators: chulett, rschirm, roy
How to call stored procedure in transformer stage
Hi,
I am using Datastage7.5.3.
How to call stored procedure in Transformer stage, is there any logic or alternative methods for this.
I need to call the stored procedure in my requirements.
Source(File) -->Transformer(STP called) -->Target(Teradata) - Will this work?
(And)
How to check the stored procedure whether it is working or not (By using the Datastage stages)which is written in teradata?
Please provide valuable information.
I am using Datastage7.5.3.
How to call stored procedure in Transformer stage, is there any logic or alternative methods for this.
I need to call the stored procedure in my requirements.
Source(File) -->Transformer(STP called) -->Target(Teradata) - Will this work?
(And)
How to check the stored procedure whether it is working or not (By using the Datastage stages)which is written in teradata?
Please provide valuable information.
Last edited by jpraveen on Thu Feb 10, 2011 1:37 am, edited 2 times in total.
Jaypee
I was thinking the SP stage had an ODBC option for 'Vendor' but on examining the docs that seems to be... incorrect.
Can you go into a little more detail on your need here? What does the proc do? Do you need to execute it only once? Or once per row? The latter is going to be quite painful from a performance standpoint, so I'm wondering what kind of alternatives might be viable here.
Can you go into a little more detail on your need here? What does the proc do? Do you need to execute it only once? Or once per row? The latter is going to be quite painful from a performance standpoint, so I'm wondering what kind of alternatives might be viable here.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Criag,
thanks for helping me about your valuble inputs.
A procedure is a specified series of actions or operations which have to be executed in the same manner in order to always obtain the same result under the same circumstances.
Let me know if i am wrong.
I have a requirement like i need to call a stored procedure in datastage job to test whether it is calling and working correctly or not?
and the DB is Teradata, DS is 7.5.3.
I am thinking in some alternative for this, but not connecting to it exactly the requirement.
thanks for helping me about your valuble inputs.
A procedure is a specified series of actions or operations which have to be executed in the same manner in order to always obtain the same result under the same circumstances.
Let me know if i am wrong.
I have a requirement like i need to call a stored procedure in datastage job to test whether it is calling and working correctly or not?
and the DB is Teradata, DS is 7.5.3.
I am thinking in some alternative for this, but not connecting to it exactly the requirement.
Jaypee
-
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA