RE: Stored procedure that calls another program

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Yes, I'm pretty sure it's still true.  That said, it's an undocumented IBM
interface and I don't want to encourage folks to use it :)
As you mentioned, there are some gotchas with a simple program call, but
more importantly, what if IBM decides to pull the plug on that capability in
some future release?

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com

-----Original Message-----
Subject: RE: Stored procedure that calls another program

Elvis,

Just to clarify, is it not still the case that ANY program object in
QSYS.LIB can be called as a stored procedure?  Technically, you should
be able to simply CALL LIB/PGM (Parm1, Parm2, Parm...) via SQL, and
expect the target to get invoked.

I understand that its easy for SQL to confuse parameter types, like
treating character literals as VARCHAR and so forth, but I use the
implied SP call methods from SQLRPGLE and not had any issues to this
point...

Just curious,
Eric DeLong