Function of Object File Name Clause: CREATE PROCEDURE and REPLACE PROCEDURE (External Form) - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The Object File Name clause specifies an explicit path to an object file that is to be used for this external procedure definition.

The syntax for this clause is either of the following:
  • CO¡ name_on_server¡ object_name
  • SO¡ name_on_server¡ object_name

The character ¡ represents a user-defined delimiter.

Perform the following procedure for specifying an object file name string.
  1. 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
  2. Type the character O to indicate this is an object file specification.
  3. Specify an arbitrary delimiter character to separate the O code and the name_on_server variable specified in the string.
  4. Specify the name assigned to the object file on the server. Do not specify an extension for this file name.

    All 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.

  5. Specify your delimiter character to separate the name_on_server from the object_name.
  6. Specify the path and name of the object file.
    Object File Location Format Specification Rules
    Client Format specification in form required by client application (for example, BTEQ).

    See client documentation for required form.
    Server Use either SOLIDUS character (/) or REVERSE SOLIDUS character (\) as separator in path specification for all platform operating systems.