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

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
xwv1596137968859.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

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

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.
override_lock
An integer value for the override lock.
If set to 1, the system does not check for the file being used before removing it.