Teradata User-Installed-Files (UIF) and the Database Search Path

In a previous article, I gave an overview of UIF features and the process required to setup, install and test a basic python UIF (MYPROJ.sha256) for generating a sha256 hash.

This article aims to expand on the initial learnings to cover off on:

  • Methods of invoking UIFs without having to specifically declare the UIF database search path for each session, i.e. SET SESSION SEARCHUIFDBPATH = <databasename>;

Using the User’ STARTUP String