Re: Mapping SQL Result Sets to Browsers

I don't work with RPG, but stored procedures are a function of the database,
not ODBC or JDBC. Hence, when I said that it'd be similar to querying the
database, no matter what the language, you can apply that to be an extention
of what'd you do when running a SQL query in RPG vs. record level access.

On Wed, Jul 2, 2008 at 4:15 PM, Nathan Andelin <nandelin@xxxxxxxxxxxx>
wrote:

Alfredo,

Let me admit that I've never written stored procedures or interfaced
with them from web applications, but my initial take is that they may be
more applicable to ODBC / JDBC environments; perhaps where the stored
procedure runs under a secure user profile. Do folks use them in RPG
programs?

Nathan

On Wed, Jul 2, 2008 at 11:49 AM, Alfredo Delgado wrote:

Nathan,

What I'd suggest is returning a SQL result set. In whatever language
you're
using you'd go through a similar process of running a query against
the DB
but you'd be calling a stored procedure instead.

Alfred

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.