I define RPG programs as store procedures pretty frequently. I started
doing it back in 1998/1999 so I could call programs remotely for our B2B
eCommerce sites (which are System i based) but I've also done the same
to create web services for things like tax, credit card authorization,
and basic address editing for our new eCommerce package which is a Java
app running under WebLogic on Solaris. The web services are also being
consumed by .Net and PHP based systems.
Matt
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Schoen
Sent: Wednesday, October 10, 2007 6: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
As an Amazon Associate we earn from qualifying purchases.