DSXchange

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?

Use the Teradata API plug-in. It might not show on the default parallel palette, but you can drag it from Stage Types in the repository view.

Server job (as posted) or parallel job (as marked)?

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 use the teradata enterprise edition stage to define custom SQL and fire it to TD.

p.s are you trying to select data from TD or insert using the custom SQL ?

I don't recommend using Teradata Enterprise for what you want to do. You would need to put the custom SQL in the -open or -close properties, but Teradata Enterprise uses a utility slot even if you are loading 0 rows to a dummy table. Use the Teradata API stage.