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

Teradata Parallel Transporter Application Programming Interface

prodname
Parallel Transporter
vrm_release
15.10
category
Programming Reference
featnum
B035-2516-035K

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