Chapter 8 Using Teradata PT in an External Stored Procedure - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2516
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata PT can be called from within an external stored procedure (XSP). An XSP is a code module, written in C or C++, which resides on the Teradata Database and is executed using the SQL CALL statement. Using Teradata PT in an XSP provides a potential performance improvement by minimizing data transfer between the client and the database server.

Calling the Teradata PT from within an XSP is only supported when using a 12.0 or later version of the Teradata Database. Using the Teradata PT in a user-defined function (UDF) is not currently supported.

Topics include:

  • Coding a Teradata PT External Stored Procedure
  • Building a Teradata PT External Stored Procedure
  • Installing a Teradata PT External Stored Procedure
  • Executing a Teradata PT External Stored Procedure
  • Getting Started with the External Stored Procedure Example