how to move UDFs from one teradata DB to another?

Database
Enthusiast

how to move UDFs from one teradata DB to another?

Hi Forum,

Im new to TD and we are replicating the DEV with PROD, i'll need to move a bunch of UDF's cane anyone give me direction on how it is done.im totally a novice in TD.
1 REPLY
Teradata Employee

Re: how to move UDFs from one teradata DB to another?

Hi,

You need to get the code .... which if you dont have .... can get using:

SHOW FUNCTION .

As an output you will get 2 files .... one a C code and two the command to compile it which can be either a REPLACE FUNCTION or a CREATE FUNCTION.

Just save C file and the replace command in a local folder .... set C code path in the REPLACE FUNCTION command and its done.

HTH!

Regards, MAC