All Forums Database
satishjampa 7 posts Joined 04/11
03 Jun 2011
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.

Adeel Chaudhry 773 posts Joined 04/08
13 Jun 2011

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

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.