Library Name Clause: CREATE FUNCTION and REPLACE FUNCTION (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 Library Name clause specifies the name of a nonstandard library file on the server that is not typically linked with the UDF being defined.

The syntax for this clause is as follows.

SL¡ library_name

The character ¡ represents a user-defined delimiter.

Follow these steps to specify a library file name string.

  1. Begin the clause with the character S to indicate this is a server specification.
  2. Type the character L to indicate this is a library file specification.
  3. Specify an arbitrary delimiter character to separate the L code and the library name specified in the string.
  4. Specify the name assigned to the non-standard library file on the server. The server automatically adds prefix or suffix values as needed.

    The path must name a server library that is already installed on the system.

    You can use either \ or / characters to specify the path for all operating systems.