The Source File Name clause specifies the location of a source file that is to be used for this external procedure definition.
The syntax for this clause is either of the following.
CS¡ name_on_server¡ source_name
SS¡ name_on_server¡ source_name
The character ¡ represents a user-defined delimiter.
Perform the following procedure for specifying a source file name string.
- Begin the clause with the appropriate client or server location code.
Location Code Storage Location of External Procedure Source or Object Code C Client S Server - Type the character S to indicate this is a source file specification.
- Specify an arbitrary delimiter character to separate the S code and the name_on_server variable specified in the string.
- Specify the name assigned to the source file on the server.
Each name_on_server must be unique among the UDFs, table UDFs, and external procedures created within the same database. If the CREATE/REPLACE PROCEDURE definition includes a nonunique name_on_server specification, the system does not create it.
- Specify your delimiter character to separate the name_on_server from the source_name.
- Specify the path and name of the source file.
You can use either \ or / characters to specify the path for all platforms.