Hi Richard,
I had some problems with NO SQL, CONTAINS SQL, READS SQL DATA and MODIFIES
SQL DATA.
I had to use MODIFIES SQL DATA (instead of Contains SQL or Reads SQL data,
which worked with Release V5R4).
At the common conference I asked Kent Milligan whether he is aware of any
modifications, but he wasn't.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Richard Schoen
Gesendet: Tuesday, 22. May 2012 15:14
An: rpg400-l@xxxxxxxxxxxx
Betreff: V6R1 and V7R1 RPG UDF Return Parms
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
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
