I am trying to submit a block of sql to Teradata and not sure how to correctly submit the SQL. I tried using the Teradata Enterprise stage using MLOAD but does not like it since the submitted SQL includes joins.
I also am going to try to us the DRS stage but do not have the Teradata ODBC installed on our server. Can the DRS support the Teradata API or does it have to be ODBC?
Teradata - Submitting SQL via DRS or Enterprise stages
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 35
- Joined: Thu Apr 19, 2007 12:42 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The original post was for Parallel. Teradata API shows up in the default Teradata stages palette for the server canvas but not for the parallel canvas. Although it doesn't show in the default palette for the parallel canvas, you can still use the Teradata API plug-in on the parallel canvas by dragging it from the repository view, Stage Types->Parallel->Database->Teradata.
You can also customize your parallel palette so that the Teradata API plug-in shows up.
You can also customize your parallel palette so that the Teradata API plug-in shows up.
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague