15.00 - About Removing 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)
Last Update
2018-09-24

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