Archives of the TeradataForum

Message Posted: Wed, 12 Dec 2007 @ 10:28:15 GMT

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

<-- Anonymously Posted: Wed, 12 Dec 2007 10:24 -->

Dear all,

It is the first time I am trying to load udf.

I am loading to_number udf from www.teradata.com and I am running the to_number.btq

This the start of the btq script

     create FUNCTION to_number(
       String VARCHAR(63)
     )RETURNS FLOAT
     LANGUAGE C
     NO SQL
     SPECIFIC to_number_1
     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'
     PARAMETER STYLE SQL;

I recieve the error

     an error:create FUNCTION to_number(
            $
       *** Failure 3706 Syntax error: Invalid statement.
                      Statement# 1, Info =8

Can you tell me why it is syntax error

I checked the syntax and couldn't find

Thanks

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