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.