Welcome to the Teradata Developer Exchange discussion forums.
For a general introduction and guidelines on posting, please see
this forum topic.
RSS feeds are available for each forum, as well as a combined
all forums feed.
Need help executing teradata macro from interface.
Hi there, I am pretty new to teradata. Recently I wrote some teradata SQL statements and be able to pull some data to view using SQL assistant for teradata. I then create/save a macro with some parameters and can be able to execute it within teradata SQL assistant, ODBC. Now I need to execute this macro from an MS-access form/interface. Usually, I use ado and dao between vba and SQL server. I've read someone could be able to do this with teradata. Can someone help me with this? Can I use ODBC for this task or I need OLEBD and connection string? Anyone has any code I can learn the syntax from? Thanks in advance.
Hi there,
I am pretty new to teradata. Recently I wrote some teradata SQL statements and be able to pull some data to view using SQL assistant for teradata. I then create/save a macro with some parameters and can be able to execute it within teradata SQL assistant, ODBC. Now I need to execute this macro from an MS-access form/interface. Usually, I use ado and dao between vba and SQL server. I've read someone could be able to do this with teradata. Can someone help me with this? Can I use ODBC for this task or I need OLEBD and connection string? Anyone has any code I can learn the syntax from?
Thanks in advance.