How to call stored procedure in transformer stage

jpraveen · Post by **jpraveen** » Wed Feb 09, 2011 7:37 am

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.

chulett · Post by **chulett** » Wed Feb 09, 2011 8:19 am

Why not use the Stored Procedure stage?

jpraveen · Post by **jpraveen** » Wed Feb 09, 2011 8:55 am

Craig,

In Datastage7.5.3 the stored procedure stage will not support the Teradata database.

chulett · Post by **chulett** » Wed Feb 09, 2011 9:06 am

Not navitely but could you not do so via ODBC?

jpraveen · Post by **jpraveen** » Wed Feb 09, 2011 9:58 pm

Hi

In ODBC stage we can select the table or we can write user-defined SQL,
my requirement is to run a teradata SP from datastage.can you explain briefly how to do so?

chulett · Post by **chulett** » Wed Feb 09, 2011 10:28 pm

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.

jpraveen · Post by **jpraveen** » Wed Feb 09, 2011 10:56 pm

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.

chulett · Post by **chulett** » Wed Feb 09, 2011 11:10 pm

I was wondering what exactly your proc, the one that you need to call does, not what one does in general.

I feel it would help to know what it does in order to help with the "how do I test it is working correctly" part.

just4geeks · Post by **just4geeks** » Wed Feb 16, 2011 9:25 am

Hi JPraveen,

Can you please let me know the solution to you issue?
As I am facing a similar issue.

Thanks In Advance.