Re: Creating a SQL REST web service

Darryl,

I have done several of these SQL IWS services in the past and never had to worry about the root.

I guess you changed the defaults supplied by IWS.

I have a video here that goes through the whole process from setting up the server to adding applications - including (towards the end) an SQL based one. But the URL and service name etc. are the same regardless of whether you are calling RPG programs or SQL. https://us02web.zoom.us/rec/share/S3buXcN6TYTBxjk7sw0rYb50iJ-7pMDIX-vP6wSRQdamUnbK0WG9o0-0OFaqr0pe.jL35bgLX4m8FgitP?startTime=1634931012000


Jon P

On Feb 28, 2024, at 3:50 PM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

Jon

That's exactly what I am doing and it don't work. IBM's documentation does
not cover everything. I think my problem lies in the document root pointing
to an invalid location. I cannot find documentation explaining the linkage
from the URL to the web service setup.

Thanks, Darryl.

On Tue, Feb 27, 2024 at 6:09 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

It sounds like you are setting up the equivalent to IWS's SQL REST service
server. So why not do that ? Do that and it will sort out all of that for
you.


Jon P.

On Feb 27, 2024, at 6:01 PM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

I need some help setting up a web service. This may belong on another
forum, but I do not know which.

I created the HTTP server for a web server.
I then created the application server.
When I run it, it does not find the web service.
I think my problem is with the root directory.
Where do I define the root directory in the set up and how does it link

up

with the root directory in the URL, example:
http://system:10020/web/service/webapp. Where do I link the

/web/services

in the definition?

The procedure is executing a simple SQL select returning a single value.

How do I verify my root directory is set correctly?

TIA, Darryl
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.