Re: PHP and SQL web developer re-creates all business logic found in RPG programs

[Scott Klement <web400@xxxxxxxxxxxxxxxx>]

No, I normally write my business logic as a service program designed to 
be easy to call directly from ILE RPG.  Then I add simple wrapper 
routines to make it compatible with either stored procedure logic or 
UDTF logic.

That way, ILE programs can call the ILE interfaces, and non-ILE programs 
can use the stored procedures.

However, I *have* used stored procedures from ILE RPG in the past, and 
have published examples in the past.  It's just not my normal way of 
doing things...

Finally, if it's important that your routines work both from embedded 
SQL languages, and from languages that use the CLI (ODBC, JDBC and PHP 
use the CLI engine under the covers) then you might consider using UDTFs 
instead of stored procedures, since they work from both environments.


Michael Ryan wrote:
> Scott...do you call the stored proc from a green screen program as
> well? If so, how do you do that? CLI? Got an example? Thanks!