Possibly.

But how much of the IBM i world has embraced and built core business functionality into SubProcedures ?

We usually use Subprocedures as small special purpose re-usable functions. When it comes to returning data we use resultsets from RPG or SQL calls.

Give me an example of your largest and most complex subprocedure and how much logic you've built in to it.

You're right it is cool to redeploy subprocedures, but re-architecting current code to send back resultsets and or be called as a stored procedure is probably just as easy.

Although I have a semi-open mind so I can be persuaded :-)

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

------------------------------

message: 2
date: Fri, 10 Aug 2012 15:30:25 -0400
from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
subject: Re: [WEB400] XMLSERVICE with .Net


On 2012-08-10, at 1:00 PM, web400-request@xxxxxxxxxxxx wrote:

Why would it need to when it can return a result set from a stored procedure ?

I personally have found no limits with jt400. Maybe I'm just too
simple :-)

In any case I plan to test XMLSERVICE more and complete a .Net service wrapper before COMMON next year for my .Net sessions.

You're completely missing the point Richard. The point is redeployment.

For example: I have many existing RPG subprocedures that I have developed as part of my existing applications. All of them return values in different forms. Some a simple 40 char field. Some a simple DS. Others a compound DS or DS array.

_None_ of those can be called from JT400 - and because it used the same underlying interface - none of them could be called from the old PHP toolkit.

If I've got all my logic in stored procedures I don't need it - but that isn't the way that most of my clients have their existing apps coded - and why would they. They were designed to feed their green screen and batch apps. They now want to use them from the web - or as a web service - or ... and to do so without wrappering them. That's where XMLSERVICE stands out.




As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.