|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/27/2008 5:24:10 PM
Posts: 2,
Visits: 36
|
|
Hi All,
Can anybody tell me, How to create and execute the UDF with simple example.
Regards
Srikant
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 9:50:54 AM
Posts: 160,
Visits: 474
|
|
Hello,
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.btq
HTH!
Regards,
Adeel
|
|
|
|