15.10 - Using the CREATE PROCEDURE SQL Statement - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

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

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.