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

[Peter Dow <petercdow@xxxxxxxxx>]

How about an SQLRPGLE service program?

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /


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" <web400-bounces@xxxxxxxxxxxxxxxxxx> wrote on 11/17/2020 09:11:39
> AM:
>
> > From: Robert Rogerson <rogersonra@xxxxxxxxx>
> > To: "Web Enabling the IBM i (AS/400 and iSeries)"
> <web400@xxxxxxxxxxxxxxxxxx>
> > Date: 11/17/2020 09:12 AM
> > Subject: [EXTERNAL] Re: [WEB400] Mixing sql and service program in
> IWS...
> > Sent by: "WEB400" <web400-bounces@xxxxxxxxxxxxxxxxxx>
> >
> > 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.