![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Thu, 19 Jul 2012 @ 16:02:30 GMT
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
| |