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