1 - 2 of 2
PREVIOUS 1 NEXT
iSeries SQL UDF gets CPF426A
I created a SQL UDF using the iNav wizard. It created the service program for me yet when I try to use the function I get CPF426A "User-defined function &5 cannot be invoked." with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.) It says the...
I created a SQL UDF using the iNav wizard. It created the service program for me yet when I try to use the function I get CPF426A "User-defined function &5 cannot be invoked." with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.) It says the...
15 pts.
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...
1 - 2 of 2
PREVIOUS 1 NEXT
