Archives of the TeradataForum

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

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

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>>