The CREATE PROCEDURE statement provides clauses that specify the name and path of the function source code file.
CREATE PROCEDURE Clause | Description |
---|---|
EXTERNAL | Use the EXTERNAL clause when the function source is in the current or default directory on the client, and no other files need to be included. The source name is the name that immediately follows the CREATE PROCEDURE keywords. If the client is..
Here is an example: CREATE PROCEDURE GetRegionXSP (INOUT region VARCHAR(64)) LANGUAGE C NO SQL EXTERNAL PARAMETER STYLE TD_GENERAL; |
EXTERNAL NAME 'string' | Use ' string ' to specify names and locations of the following:
You can also use 'string' to specify that the source or include files not be stored. If the client is..
Here is an example: CREATE PROCEDURE GetRegionXSP (INOUT region VARCHAR(64)) LANGUAGE C NO SQL EXTERNAL NAME 'CS!getregion!xspsrc/getregion.c!F!xsp_getregion' PARAMETER STYLE TD_GENERAL; where...
|
EXTERNAL NAME function_name | Use EXTERNAL NAME function_name when the function source is in the current or default directory on the client, and no other files need to be included. The source name is the same as function_name. If the client is...
Here is an example where function_name is xsp_getregion: CREATE PROCEDURE GetRegionXSP (INOUT region VARCHAR(64)) LANGUAGE C NO SQL EXTERNAL NAME xsp_getregion PARAMETER STYLE TD_GENERAL; |
For more information on CREATE PROCEDURE and the EXTERNAL clause, see Teradata Vantageā¢ - SQL Data Definition Language Detailed Topics, B035-1184.