Re: Mixing sql and service program in IWS...

Thanks all.  My question is answered.  I was really looking for
confirmation that I couldn't mix sql and service program web services out
of the box.

Thanks,

Rob

On Tue, Nov 17, 2020 at 3:29 PM Peter Dow <[email protected]> wrote:

> How about an SQLRPGLE service program?
>
> --
> *Peter Dow* /
> Dow Software Services, Inc.
> 909 793-9050
> [email protected] <mailto:[email protected]>
> [email protected] <mailto:[email protected]> /
>
>
> On 11/17/2020 11:39 AM, Nadir Amra wrote:
> > Rob, no you  cannot.  But if  you use an HTTP server you can always play
> > with URL mapping so from the point  of view of clients it  does  look
> like
> > it is the same  resource.  In admin  and  programming  guide there is
> some
> >   examples of URL mapping, although not related to this issue but would
> be
> > a solution to what you want to achieve.
> >
> >
> >
> >
> > "WEB400" <[email protected]> wrote on 11/17/2020
> 09:11:39
> > AM:
> >
> >> From: Robert Rogerson <[email protected]>
> >> To: "Web Enabling the IBM i (AS/400 and iSeries)"
> > <[email protected]>
> >> Date: 11/17/2020 09:12 AM
> >> Subject: [EXTERNAL] Re: [WEB400] Mixing sql and service program in
> > IWS...
> >> Sent by: "WEB400" <[email protected]>
> >>
> >> Thanks Nadir, but I guess I wasn't clear in my question.
> >>  From what you said I create two web services students_srvpgm and
> >> students_sql
> >>
> >> Is there a way to do this so that the resource /students is used by
> > both?
> >> So as i mentioned above (GET) /students executes a (SELECT *) SQL
> > statement
> >> (web service students_sql)
> >> and (POST) /students to call an RPG service program  (web service
> >> students_srvpgm)
> >>
> >> I guess what I'm trying to ask is can two web services point to the same
> >> resource (/students) and if so how do I do it.
> >> I tried creating the sql web service but I got an error saying that the
> >> resource /students already existed.
> >>
> >
> >
>
> --
> This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
> list
> To post a message email: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/web400
> or email: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/web400.
>
>
-- 
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.