Re: Mapping SQL Result Sets to Browsers

["Alfredo Delgado" <adelgado@xxxxxxxxxxxxxxxxx>]

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.