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

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.

Thanks,

Rob

On Tue, Nov 17, 2020 at 12:13 AM Nadir Amra <amra-r/[email protected]> wrote:

> Not in same web service.   But different web services,  yes.
>
>
>
> "WEB400" <[email protected]> wrote on 11/16/2020 09:12:48
> PM:
>
> > From: Robert Rogerson <[email protected]>
> > To: "Web Enabling the IBM i (AS/400 and iSeries)"
> <[email protected]>
> > Date: 11/16/2020 09:13 PM
> > Subject: [EXTERNAL] [WEB400] Mixing sql and service program in IWS...
> > Sent by: "WEB400" <[email protected]>
> >
> > I watched a youtube video by Tim Rowe where his demo was using SQL as a
> web
> > service.  Very nice.
> >
> > My simple question is can you mix a service program web service and an
> sql
> > web service.
> >
> > For example, If I wanted (GET) /students to execute a (SELECT *) SQL
> > statement but I wanted (POST) /students to call an RPG service program.
> >
>
>
>
> --
> 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.