A TD_ANYTYPE parameter type can accept any system-defined data type or UDT; therefore, TD_ANYTYPE arguments are passed in as void *.
Here is an example of how to declare a scalar function that uses TD_ANYTYPE types:
/***** C source file name: ascii.c *****/ #define SQL_TEXT Latin_Text #include <sqltypes_td.h> void ascii( void * inputStr, void * result, ... ) { ... }
The corresponding CREATE FUNCTION statement looks like this:
CREATE FUNCTION ascii( str TD_ANYTYPE ) RETURNS TD_ANYTYPE LANGUAGE C NO SQL SPECIFIC ascii EXTERNAL NAME 'CS!ascii!UDFs/ascii.c' PARAMETER STYLE SQL;