×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I have a customer who has created an SQL UDF that returns a '0' or '1' as a response.
The UDF worked on V5R4, but does not work on V6R1 or V7R1.
Does anyone know if the Create Function syntax has changed ?
No joblog or SQL errors are occurring. Just no return value. Always comes back NULL.
I whittled the RPG program down to a simple 1 liner that returns a value of 0 and still no joy.
I also changed from a VARCHAR to a CHAR and no joy.
I am wondering if the UDF declaration syntax has changed for newer releases.
Here's what we are using:
CREATE FUNCTION DSCBASDTA/@RYCHKMXD ( VARCHAR(2),DECIMAL(6,0),DECIMAL(6,0),VARCHAR(20))
RETURNS VARCHAR(1)
LANGUAGE RPGLE
EXTERNAL NAME 'DSCBASOBJ/OBRYCHKMXD (@RYCHKMXD )'
DETERMINISTIC
NO SQL
Any input would be appreciated.
Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxx>
Web Site:
http://www.rjssoftware.com<
http://www.rjssoftware.com/>
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
midrange.com
