Archives of the TeradataForum

Message Posted: Thu, 13 Dec 2007 @ 11:09:07 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

What version of Teradata are you running?

     Select * from dbc.dbcinfo;

UDF's were introduced in V2R5.0 (or was it V2R5.1?) so it won't work in earlier versions.

     > > EXTERNAL NAME 'SI!to_number!C:\program
     files\ncr\tdat\tdconfig\teradata\tdbs_udf\usr\to_number.h!SS!to_number_1!C:\
     program files\ncr\tdat\tdconfig\teradata\tdbs_udf\usr\to_number_1.c'

The above clause means that the files for your UDF are located on the server. Is that the case? Or are they located on the client from which you are running bteq? If so, try using "CI", "CS" in place of "SI" and "SS". Also make sure the files are in the locations specified above. I would have expected a different error message (e.g. "a file not found" type of message) if this was the problem.

Good luck

Glenn Mc

	<Prev	Next>		<<First	<Prev	Next>	Last>>