15.00 - About Redistributing External Language Scripts - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)

About Redistributing External Language Scripts

You might need to redistribute an installed file to all nodes of a database system during copying, migration, or system restore operations.

To redistribute a previously registered file to all nodes of a database system, use the REDISTRIBUTE_FILE external stored procedure. The file to be redistributed must have been registered using the INSTALL_FILE external stored procedure.

Before You Begin

You must have the EXECUTE privilege on the REDISTRIBUTE_FILE procedure and the CREATE EXTERNAL PROCEDURE privilege on the current database.

SYSUIF.REDISTRIBUTE_FILE

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);

where:

 

Argument …

Specifies …

uif_name

the SQL name associated with the user-installed script. 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.

Example  

Consider a file that was registered with the JXSP database using the following statements:

   CALL SYSUIF.REDISTRIBUTE_FILE('mapper');