Using the CREATE PROCEDURE SQL Statement - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
16.20
Published
November 2020
Language
English (United States)
Last Update
2020-11-19
dita:mapPath
ghk1527114222323.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2516
lifecycle
previous
Product Category
Teradata Tools and Utilities

The CREATE PROCEDURE SQL statement is used to link the dynamic library containing the user created XSP to the Teradata Database. The Teradata Database user must have the CREATE EXTERNAL PROCEDURE permission to be able to issue the CREATE PROCEDURE SQL statement.

The following is an example of a CREATE PROCEDURE SQL statement for an XSP which uses the Teradata PT:



For more information on using the CREATE PROCEDURE SQL statement, see SQL External Routine Programming (B035-1147).