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 <petercdow@xxxxxxxxx> wrote:

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.

--
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.