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@xxxxxxxxxx> wrote:

Not in same web service. But different web services, yes.



"WEB400" <web400-bounces@xxxxxxxxxxxxxxxxxx> wrote on 11/16/2020 09:12:48
PM:

From: Robert Rogerson <rogersonra@xxxxxxxxx>
To: "Web Enabling the IBM i (AS/400 and iSeries)"

<web400@xxxxxxxxxxxxxxxxxx>

Date: 11/16/2020 09:13 PM
Subject: [EXTERNAL] [WEB400] Mixing sql and service program in IWS...
Sent by: "WEB400" <web400-bounces@xxxxxxxxxxxxxxxxxx>

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: WEB400@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.