Teradata provides a wide range of built-in functions that address the needs of typical users. In those cases when standard functions are inadequate, Teradata allows you to define user-defined functions (UDFs) and external stored procedures that extend the capability of normal SQL within the database. You can create your own UDFs and external stored procedures or use UDFs and external stored procedures that are provided by Teradata.
To create and use UDFs and external stored procedures, you need to use the External Routine Installation Tool and External Routine Migration Tool. Users must authenticate themselves using a Personal Access Token and the private key used to generate the token before they can create or use UDFs and external stored procedures. Follow the instructions for Creating a Personal Access Token and store the PAT with the private key for use during the migration of SQL scripts and installation of UDFs and external stored procedures.
Use the XRMigrationTool to migrate the SQL scripts that create UDFs and external stored procedures for VantageCloud Lake. Once migrated, run the scripts to install the UDFs and external stored procedures. Follow the instructions for Running the External Routine Migration Tool and Running Migrated Scripts to learn how to migrate and run the scripts.