Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 Jul 2012 @ 16:02:30 GMT


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


Subj:   Replace UDF failing with syntax error.
 
From:   Ravi.Singh

Hi Folks,

I am getting this weird syntax error while trying to create this UDF in TD 14.0.0.1. Can anyone suggest what am I missing here?

     REPLACE FUNCTION SYSLIB.SelectClassification
       ( CURRENT_SESSION smallint, INPUT_ROW smallint )
       RETURNS char(1) SPECIFIC SYSLIB.SelectClassification
       LANGUAGE C DETERMINSTIC NO SQL
       EXTERNAL NAME 'cs!SelectClassification!udf_SelectClassification.c'
       PARAMETER STYLE TD_GENERAL;

     NO SQL
        $
     *** Failure 3707 Syntax error, expected something like a 'PROTECTION'
     keyword between the word 'DETERMINSTIC' and the 'NO' keyword.
                     Statement# 1, Info =173
     *** Total elapsed time was 2 seconds.

Regards,

Ravi Singh



     
  <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