RE: V6R1 and V7R1 RPG UDF Return Parms

Solved it with this:

CREATE FUNCTION RJSDEVLIB/@RYCHKMXD (
VARCHAR(2),DECIMAL(6,0),DECIMAL(6,0),VARCHAR(20))
RETURNS VARCHAR(1)
LANGUAGE RPGLE
EXTERNAL NAME 'RJSDEVLIB/OBXYCHKMXD(@RYCHKMXD)'
DETERMINISTIC
NO SQL
PARAMETER STYLE GENERAL
PROGRAM TYPE sub

Thanks for the example Scott Klement :-)

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

-----Original Message-----

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