The SYSUIF.REPLACE_FILE external stored procedure has the following definition:
SYSUIF.REPLACE_FILE (
IN uif_name VARCHAR(128)NOT CASESPECIFIC CHARACTER SET UNICODE,
IN uif_filename VARCHAR(256) CASESPECIFIC CHARACTER SET UNICODE,
IN locspec VARCHAR(1024)CASESPECIFIC CHARACTER SET UNICODE,
INoverride_lock int
);
Syntax Elements
- uif_name
- The SQL name associated with the user-installed file. Cannot have a database name associated with it, as the file is installed in the current database.
- The uif_name must be unique within a database.
- The uif_name can be any valid Teradata identifier.
- uif_filename
- The name of file with the extension (if any). This can be any valid LINUX file name.
- locspec
- The location of the replacement file. The format is identical to the SYSUIF.INSTALL_FILE locspec parameter.
- The first two characters of the locspec string specify whether the replacement archive file is on the client or on the database server. If the first two characters are:
- CJ, then the external language script is on the client.
- SJ, then the external language 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 remaining characters in the locspec string specify the file path.
-
| External Language Script Location |
File Path |
|---|
| Client |
Client-interpreted path that specifies the location and name of the file. |
| Database server |
Full or relative path that specifies the location and name of the file. If the file path is relative, the full path to the file is formed by appending the relative path to the default path for source code on the server.
|
- If the replacement file does not exist in the current database, the REPLACE_FILE creates and registers a new file with the database.
- The new file is updated and distributed to all nodes. If a node is down, the pending file copy is recorded and copied when the node comes back up.
- override_lock
- An integer value for the override lock.
- If a script is being run in the database where the file is being replaced, all files in that database are locked with read-only access. REPLACE_FILE must wait until the script is run and permission is granted to write the file. If override_lock is set to 1, the file is replaced even if a script is being run.
- The value of override_lock is 1 or 0.