Richard,
I agree, this is an extremely valuable feature of OS400, and I am using this in limited fashion now. Technically, OS400 allows any PGM object to be called as an external stored procedure, which makes SQL a superior remote call facility. I am using it for address validation and geocoding, but only using it to call host-to-host.
Eric
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Richard Schoen
Sent: Wednesday, October 10, 2007 5:36 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL User Defined Functions
Is anybody else wrapping RPG logic into SQL user defined functions or
stored procedures on the iSeries/Systemi ?
This is a powerful way to bring RPG logic into a reporting tool, web app
or desktop application.
I recently did a project for a new document management customer where we
were able to extend our WebDocs security by simply creating a user
defined function that tied into their business application to determine
additional document permissions. One little service program, an
additional WHERE clause and viola !!
I would be interested in hearing your usage of these capabilities.
Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT
midrange.com
