Using the CREATE PROCEDURE SQL Statement - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

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

Using the CREATE PROCEDURE SQL Statement

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:

CREATE PROCEDURE tptapixsp
(
IN operatortype VARCHAR(64),
	IN CONFIGFILENAME varchar(64),
	IN datafilename VARCHAR(64)
)
 
LANGUAGE CPP
 
 
 
 
MODIFIES SQL DATA
 
 
 
 
 
 
 
 
EXTERNAL NAME
'SP!CLI!SP!/xsptest/xsptest.so!F!tptapixsp'
 
 
PARAMETER STYLE SQL;

 

 

 

For more information on using the CREATE PROCEDURE SQL statement, see SQL External Routine Programming.