16.20 - locspec - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Administration
Programming Reference
Publication ID
B035-1210-162K
Language
English (United States)

The location of the script file to register.

The first two characters of the locspec string specify whether the external language script is on the client or on the database server. If the first two characters are:

  • C, then the script is on the client.
  • S, then the script is on the database server.

The third character of the locspec string is a delimiter that you choose to separate the first two characters from the remaining characters in the locspec string. The delimiter is a single character.

The file_type is 'Z' text file or 'B' binary file.

The remaining characters in the locspec string specify the file path.

If the file is on the:

  • client, then the file path is a client-interpreted path that specifies the location and name of the file.
  • database server, then the file path is a full or relative path specifying the location and name of the file.

    If the file path is relative, the full path to the archive file is formed by appending the relative path to the default path for source code on the server.

    To determine the default path for source code, use the -o option of the cufconfig utility and find the setting for the SourceDirectoryPath field:

         cufconfig -o

    For information on cufconfig, see Teradata Vantage™ - Database Utilities , B035-1102 .

Example

The following statement calls SYSUIF.INSTALL_FILE to install a Python script and distribute the file to all nodes:

  CALL SYSUIF.INSTALL_FILE('mapper', 'mapper.py',
  'cz!mapper.py!/tmp/mapper.py');