The Teradata Data Set Builder for SAS and Analytic Data Set (ADS) Generator products, and products that are built upon them, offer Predictive Model Markup Language (PMML) scoring functions that require that certain User Defined Functions (UDFs) be installed in Teradata.
-
Execute the Install or Uninstall UDFs program item in the Teradata Warehouse Miner program group.
This program creates the UDFs by locating the Teradata Client Utility BTEQ. If it exists on the system, you can proceed with the load. Otherwise, an error occurs.
-
You will be prompted to select which UDF install or uninstall function to perform and to enter the Hostname, Userid, Password and Database (which should be the Metadata Database) to load the UDFs into.
This requires an appropriate entry in the Hosts file to connect properly. See Executing Teradata Client Utilities. The BTEQ utility is then invoked to create all of the necessary UDFs.
Any existing UDFs with the same names will be replaced during the execution of the PMML install function. -
If the UDFs fail to install properly, even though the BTEQ utility, Hosts file entry, and proper database permissions are all in place, an alternative method of installation can be attempted.
From the command line, change the current directory:
cd <TWM product directory>\Scripts\UDF Install and Scripts
-
Issue the following command: InstallUdfs -c ASCII.
This will lead to the prompts described above.