Re: simple web service

Hi Sean,
We had a similar situation, meaning our system A (DB2 on POWER9) needs to
check some rows state on our system B (SQL Server running a document
management system).
Instead of having a web service running on system B, which implies some
coding on system B, and being both systems on the same internal net, we
resolved to implement ARDGATE software: on system A a relational DB entry
is defined and it points to the SQL Server instance on system B, and when
it's the case system A performs an SQL select statement to check row' state
on system B.

If you think it may be of help I can share other details.

Il giorno lun 20 dic 2021 alle ore 10:23 Sean Courtney <
scourtney@xxxxxxxxxxx> ha scritto:

Hello all,



I have two systems hosting order data. When a user want to make a change
to an order on system A he/she must first verify the order state on system
B.



We want to implement a web service to achieve the above so when the user
accesses an order on System A and a request is automatically sent to system
B and the current order state is returned.



System A is an AS400 (DB2) and System B is Windows Box running MS SQL
Server.



Has anybody go a simple example for doing the above ??



Mit freundlichen Grüßen / Kind regards / Bien à vous,



Sean Courtney



Email : <mailto:scourtney@xxxxxxxxxxx?subject=Bitte%20kontaktieren>
scourtney@xxxxxxxxxxx





--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com