× 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.



Richard,

I use UDTFs for this sort of thing. They are easy to consume from RPG as well as other languages. (I consume them with RPG & PHP primarily -- but you could do it from .Net or Java if you wanted to.)

Here's the handout from a I talk I give on that stuff (it starts out talking about UDFs but continues with UDTFs) There are links at the end to articles:

http://www.scottklement.com/presentations/#RPGUDF


On 4/2/2010 10:59 AM, Richard Schoen wrote:
Hello All,



I would like to hear input on the best way to do an MVC style of
patterning with RPG business logic where the business layer is entirely
separate from the client whether it be another green screen app, a web
app or a client side application done in VB.Net.



Looking to build RPG based business logic that can return resultsets and
be used by other RPG programs, Java, .Net or PHP client apps.



Basically the idea is to have one business object that can be used by
any of the layers.



If this was just a simple program call with passing parms, then having a
callable program exposed as a stored procedure seems reasonable.



Where it gets more interesting is with resultsets as they are not easily
consumed from another RPG program.



As a similar point of reference on the Windows side of the fence we have
built a business object that can read/write data via SQL or record level
as well as call programs and this code can be used from any Windows
based application. This is an example where we've built a standardized
API that can be used from any Windows based language.



I suppose exchanging XML or JSON resultsets might be one way to do it as
we're looking at using jQuery or ExtJS based UI's



Any input or thoughts 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





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.