UDF creation error

Connectivity
Enthusiast

UDF creation error

Hi,
I had created an UDF in dev and tested my code around it..when i tried to create it on prod, i gives me invalid statement error even though the syntax is correct and very much the same as is working in DEV..
is it possible that UDFs need to be enabled or something extra needs to be installed on server? hw do i check if UDFs are enabled in PROD?

create FUNCTION dbname.udfname(param1 integer)
returns char(4)
LANGUAGE C NO SQL
RETURNS NULL ON NULL INPUT
SPECIFIC udfname
EXTERNAL NAME 'CS!code!/path/user/code.c'
PARAMETER STYLE TD_GENERAL;

create FUNCTION dbname.udfname(param1 integer)
$
*** Failure 3706 Syntax error: Invalid statement.
Statement# 1, Info =8
*** Total elapsed time was 1 second.

PS. the c code exists in given location and works fine.
Regards,
Manish
1 REPLY
Fan

Re: UDF creation error

I checked your syntax and it was fine. What version of Teradata are you using? The following query should show how to see if UDFs are in the system:

sel * from dbc.udfinfo;