About Removing External Language Scripts - Teradata Database

About Removing External Language Scripts

To remove an external language script that was previously registered using SYSUIF.INSTALL_FILE, run SYSUIF.REMOVE_FILE.

Before You Begin

Complete the following steps before you remove a registered external language script:

1 Verify that you have the EXECUTE privilege on the REMOVE_FILE external stored procedure.

2 Check if the default database is where the script file was registered. If not, use the DATABASE statement to change the default database.

3 Verify that you have the DROP PROCEDURE or DROP FUNCTION privilege on either:

The default database

The file that you are removing from the default database.

SYSUIF.REMOVE_FILE

The SYSUIF.REMOVE_FILE external stored procedure has this definition:

   SYSUIF.REMOVE_FILE(

      IN uif_name  VARCHAR(128)NOT CASESPECIFIC CHARACTER SET UNICODE,

       IN override_lock int);

where:

Argument …	Specifies …
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.
override_lock	an integer value for the override lock. The value of override_lock is 1 or 0. If set to 1, the system does not check for the file being used before removing it.

Example  

The following statement removes the registered file:

CALL SYSUIF.REMOVE_FILE('mapper',1);