topic Re: Calling Teradata Store procedure in Talend Studio

Calling Teradata Store procedure

Anonymous — Thu, 11 Apr 2013 15:41:26 GMT

Hi,
Please let me know is there any way I can call store procedure from Teradata .
Thanks and Regards,
Biswajit

Re: Calling Teradata Store procedure

Anonymous — Thu, 11 Apr 2013 18:07:53 GMT

Hi,
You can use tTeradataRow component to execute your store procedure.
Best Regards,
Mayur

Re: Calling Teradata Store procedure

Anonymous — Fri, 12 Apr 2013 06:36:22 GMT

Hi Mayur ,
Thanks for the reply. Is there any way I can use BTEQ native Teradata utility. iTeradataRow is using jdbc driver , I want to do it using teradata utilities like BTEQ.

Thanks and Regards,
Biswajit

Re: Calling Teradata Store procedure

Anonymous — Fri, 12 Apr 2013 11:16:52 GMT

Hey Mayur,
How do you get Out params using tTeradataRow
Is there a sample e.g.?
Regards,
Sam

Re: Calling Teradata Store procedure

Anonymous — Sun, 02 Jun 2013 20:14:29 GMT

Hi Biswajit,
Their is no direct functionality to get out params from tTeradatRow. You can use a work around to do the same.
In your procedure insert the output parameter value in the tmp table before completion of the procedure. Later on you can use this param value by pulling it from tmp table.
Best Regards,
Mayur