Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2013-04-11 11:41 AM

Calling Teradata Store procedure

Hi,
Please let me know is there any way I can call store procedure from Teradata .
Thanks and Regards,
Biswajit
Labels (2)
Labels
191 Views
0 Likes
4 Replies
Anonymous
Not applicable
‎2013-04-11 02:07 PM
Author

Hi,
You can use tTeradataRow component to execute your store procedure.
Best Regards,
Mayur
191 Views
0 Likes
Anonymous
Not applicable
‎2013-04-12 02:36 AM
Author

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
191 Views
0 Likes
Anonymous
Not applicable
‎2013-04-12 07:16 AM
Author

Hey Mayur,
How do you get Out params using tTeradataRow
Is there a sample e.g.?
Regards,
Sam
191 Views
0 Likes
Anonymous
Not applicable
‎2013-06-02 04:14 PM
Author

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
191 Views
0 Likes