Calling Teradata Store procedure

Highlighted
One Star

Calling Teradata Store procedure

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

Re: Calling Teradata Store procedure

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

Re: Calling Teradata Store procedure

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
One Star

Re: Calling Teradata Store procedure

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

Re: Calling Teradata Store procedure

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

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads