InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 02:55:24 GMT20http://www.teradata.com/teradataforum/Topic11466-11-1.aspxHello,Following is the sample UDF code file, save it as "udfvarchartest.c":#define SQL_TEXT Latin_Text#include "sqltypes_td.h"void udfvarchartest( VARCHAR_LATIN *var_in_varchar1, VARCHAR_LATIN *var_out_varchar1){ strcpy(var_out_varchar1, var_in_varchar1); return;}Following is the code for its compilation save it as "udfvarchartest.btq":.LOGON username/pass;DATABASE db;REPLACE FUNCTION udfvarchartest (var1 VARCHAR(20)) RETURNS VARCHAR(20) LANGUAGE C NO SQL EXTERNAL NAME 'CS!udfvarchartest!udfvarchartest.c!F!udfvarchartest' PARAMETER STYLE TD_GENERAL;.LOGOFF;Place both the files in one folder e.g. c:\UDF and run bteq < udfvarchartest.btqHTH!Regards,AdeelWed, 21 May 2008 07:23:31 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic11466-11-1.aspxHi All,Can anybody tell me, How to create and execute the UDF with simple example.RegardsSrikantFri, 16 May 2008 04:59:45 GMTsrikant9099