Teradata - Submitting SQL via DRS or Enterprise stages

dav_mcnair · Post by **dav_mcnair** » Tue Apr 22, 2008 3:03 pm

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?

toshea · Post by **toshea** » Fri Aug 15, 2008 12:24 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 15, 2008 12:28 am

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

toshea · Post by **toshea** » Fri Aug 15, 2008 12:36 am

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.

DS_FocusGroup · Post by **DS_FocusGroup** » Fri Aug 15, 2008 12:57 am

You can use the teradata enterprise edition stage to define custom SQL and fire it to TD.

DS_FocusGroup · Post by **DS_FocusGroup** » Fri Aug 15, 2008 1:06 am

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

toshea · Post by **toshea** » Fri Aug 15, 2008 7:03 am

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.