Re: simple web service

There is a DRDA service for Microsoft SQL:

https://docs.microsoft.com/en-us/host-integration-server/core/planning-and-architecting-solutions-using-microsoft-service-for-drda

That means, that it is possible to use DDM (aka DRDA) to access the database tables directly from SQL.

That would make it fairly transparent where the orders are.

I never used it - but I have used DDM/DRDA to access remote tables, without problems.

HTh
Daniel

Von meinem iPhone gesendet

Am 21.12.2021 um 02:08 schrieb Richard Schoen <richard@xxxxxxxxxxxxxxxxx>:

You don't necessarily need a web service.

RPG JDBC Samples from Scott Klement:
https://www.scottklement.com/jdbc/

You could also write a little Python script to do the checks using the freetds database driver that is part of the open source tools. The script could return data or simply a success/failure or the order status and other data for RPG consumption.

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------

message: 3
date: Mon, 20 Dec 2021 10:23:12 +0100
from: "Sean Courtney" <scourtney@xxxxxxxxxxx>
subject: simple web service

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