Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: UDF Failure 3706 Syntax error: Invalid statement
 
From:   McCall, Glenn David

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


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