Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   UDF Failure 3706 Syntax error: Invalid statement
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016