Re: MVC Examples/Concepts with RPG

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

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