ODBC Connector

Back Next

Calling a stored procedure

You can use an ODBC connection in a mapping to call a stored procedure or process saved queries when you connect to Teradata.

When you configure the ODBC connection, you must select the ODBC subtype as Teradata. You can then use the ODBC connection in a SQL transformation to call a stored procedure or to process saved queries.

You can use the SQL transformation to process SQL queries midstream in a pipeline. You can configure the SQL transformation to process the following types of SQL statements:

Stored procedure: Stored procedures reside in the database and run within the database. When you configure the SQL transformation to process a stored procedure, it passes input parameters to the stored procedure. The stored procedure passes the return value or values to the output fields of the transformation.
SQL Query: You can configure the SQL transformation to process a saved query that you create in Data Integration or you can enter a query in the SQL editor.
You can also parameterize the ODBC connection with the Teradata ODBC subtype in an SQL transformation.

For more information about SQL transformations, see

Transformations

in the Data Integration documentation.

Mappings and mapping tasks with ODBC Connector

Rules and guidelines for calling a stored procedure

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal