Dropping the User Defined Functions

Log in to the server as the user with the required permissions.
Navigate to the /opt/protegrity/<DBP_version>/databaseprotector/teradata/sqlscripts/ directory.

To start the bteq utility, run the following command:

/opt/protegrity/databaseprotector/teradata/sqlscripts/ # bteq

Press ENTER.
The prompt to log in to the database appears.
```
Enter your logon or BTEQ command:
```
To log in to the database, run the following command:
```
.logon <username>
```
Press ENTER.
The prompt to enter the database password appears.
Enter the database password.
Press ENTER.
The connection to the Teradata database is established successfully.
```
*** Logon successfully completed.
```
To remove the installed UDFs from the database, run the following query:
```
.run file=dropobjects.sql
```

Press ENTER.
The script removes each of the UDFs and the following message for each of the removed UDF appears.

*** Function has been dropped.
*** Warning: 5607 Check output for possible warnings encountered in compiling and/or linking UDF/XSP/UDM/UDT.
*** Total elapsed time was 1 second.

To remove the Varchar Unicode UDFs from the database, run the following query:
```
.run file=dropvarcharunicode.sql
```

Press ENTER.
The script removes each of the UDFs and the following message for each of the removed UDF appears.

*** Function has been dropped.
*** Warning: 5607 Check output for possible warnings encountered in compiling and/or linking UDF/XSP/UDM/UDT.
*** Total elapsed time was 1 second.

To remove the Decimal UDFs from the database, run the following query:
```
.run file=dropdecimalobjects.sql 
```

Press ENTER.
The script removes each of the UDFs and the following message for each of the removed UDF appears.

*** Function has been dropped.
*** Warning: 5607 Check output for possible warnings encountered in compiling and/or linking UDF/XSP/UDM/UDT.
*** Total elapsed time was 1 second.

Feedback

Was this page helpful?

Last modified : May 08, 2026