SYSUIF.REDISTRIBUTE_FILE | SQL Operators & User-Defined Functions | Vantage - 17.10 - SYSUIF.REDISTRIBUTE_FILE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

The SYSUIF.REDISTRIBUTE_FILE system external stored procedure has the following definition:

SYSUIF.REDISTRIBUTE_FILE(
   IN uif_name VARCHAR(128)NOT CASESPECIFIC CHARACTER SET UNICODE);

Syntax Elements

uif_name
The SQL name associated with the user-installed file. It cannot have a database name associated with it, as the file is always installed in the current database.
The uif_name should be unique within a database.
The uif_name can be any valid Teradata identifier.
If the script file does not exist in the current database, the REDISTRIBUTE_FILE operation fails.
If the script file is found, the installed file is retrieved from its internal table location and redistributed to all nodes of the system. If a node is down, the file is copied over when the node comes back up.