PREV 1 NEXT
User defined function for an expression
I have a user defined function that returns a single scalar value, e.g. a formatted name. Is it possible to reference the UDF as the value of a field in SSRS 2008? If so, how? Thanks.
I have a user defined function that returns a single scalar value, e.g. a formatted name. Is it possible to reference the UDF as the value of a field in SSRS 2008? If so, how? Thanks.
5 pts.
Using MySQL message API on Windows
I am new to MySQL message API. I want to use MySQL message API on Windows platform. But MySQL message API is tested and developed on open source platform (Linux, Unix, etc). I think MySQL message API is nothing but a udf, which uses spread toolkit (spread daemon). So I tried to build a dll for...
I am new to MySQL message API. I want to use MySQL message API on Windows platform. But MySQL message API is tested and developed on open source platform (Linux, Unix, etc). I think MySQL message API is nothing but a udf, which uses spread toolkit (spread daemon). So I tried to build a dll for...
How to automatically update Child Table with Insert Trigger and Table-UDF
I have SQL Server 2008 and Visual Studio 2008 and am trying to automatically insert new records into a child table based on new inserts into its parent table. I know that this should be simple: via an insert trigger. However, the complexity is that the new records into the child table need to be...
I have SQL Server 2008 and Visual Studio 2008 and am trying to automatically insert new records into a child table based on new inserts into its parent table. I know that this should be simple: via an insert trigger. However, the complexity is that the new records into the child table need to be...
UDF returning DATE always fails
We have legacy tables storing dates as integer fields... ie 2012001. I have built a UDF that parses, joins, and casts the segments to a DATE type. This works fine until I hit about 800 rows and I get a non-specific SQL error. If I return a CHAR(10) with the formatted date, I get no error. Only when...
We have legacy tables storing dates as integer fields... ie 2012001. I have built a UDF that parses, joins, and casts the segments to a DATE type. This works fine until I hit about 800 rows and I get a non-specific SQL error. If I return a CHAR(10) with the formatted date, I get no error. Only when...
Comparing views, user-defined functions and stored procedures in SQL
How do views, user-defined functions (UDFs) and stored procedures work in SQL, and what conditions are there on their usage?
How do views, user-defined functions (UDFs) and stored procedures work in SQL, and what conditions are there on their usage?
Having trouble with DB2/400 UDF returning a table.
I've written a test RPGLE program (not a service program) to return a table that for testing puposes I'm returning 1 row and 1 hard coded return column that is defined as varchar. I'm building the return value by concatonating the input parameters. Anyhow I tried running it using interactive...
I've written a test RPGLE program (not a service program) to return a table that for testing puposes I'm returning 1 row and 1 hard coded return column that is defined as varchar. I'm building the return value by concatonating the input parameters. Anyhow I tried running it using interactive...
UDF unable to load Java class. What do I need to do to make this work?
Hi all, Right now I find myself in a position of doing it first, and learn setting up Java UDF later! I have managed to get the UDF registered but having problem getting the Java code to work. I need assistance to get this Double Metaphone Java UDF to work pretty quickly. Here is what I tried...
Hi all, Right now I find myself in a position of doing it first, and learn setting up Java UDF later! I have managed to get the UDF registered but having problem getting the Java code to work. I need assistance to get this Double Metaphone Java UDF to work pretty quickly. Here is what I tried...
PREV 1 NEXT
