Re: Writing an Open Access handle that will either read/write to the Db2 file or make a REST call -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Subject: Re: Writing an Open Access handle that will either read/write to the Db2 file or make a REST call
From: "D*B" <dieter.bender@xxxxxxxxxxxx>
Date: Tue, 15 Jan 2019 17:59:16 +0100
Arc-authentication-results: i=1; mx.google.com; spf=neutral (google.com: 212.227.126.134 is neither permitted nor denied by best guess record for domain of dieter.bender@xxxxxxxxxxxx) smtp.mailfrom=dieter.bender@xxxxxxxxxxxx
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=importance:content-transfer-encoding:mime-version:date:subject:to :from:message-id; bh=iOxVjHjTwN5jCdTkrOAV169P5MNNtXZ/Cijo8s8xKNs=; b=fictNjJx2Wow3ArolBo55+4ecl4PaUPWIEUfHHfuNbsrJkXOJj1BQiQQkURbe0cR0J IpluAFIx6ic/0Acmkybpfxh3/nlp3eiagU7azq9FoqXflPI3VKB3jBUU5ojTZyaVwjlD UIrXgK78sw1h9K52PhFtRNhjnF88BQnqMI5hkwOcxjbDinFP4ucbD8UphX7mA1z60BAH UlaNdkAm5mfOrkzYPlU5vJjh6q4gISHvUzVakvUS4ABO++k9cM4qqSteqfdKJ1PMNxTK 1FgYmG4Q+zCNA8ytxBg6eztAEEuex8uYiAnhvFQsQGBnDtNfNop2wvtkvMTKdKDg1KZt R5Kw==
Arc-seal: i=1; a=rsa-sha256; t=1547571545; cv=none; d=google.com; s=arc-20160816; b=niw6nLMnCoSivIkB0kMUQgllBhWUfzQKTlm5Sllq+PyueNJnvdraclrDkIXnpfYa1+ a85bYK4/2eqG1/Zin1SKC2pi+n0kIbMm1bL8N8zAP4BecRdo4TBE9C0bq327H/oyy0av TDxP1w3sXkI1W3tkD+fp0e0MeE5xMQBhL2pxvP2boCL3/S5z50u8PXfFrTGi+EA8hd9a 9HI/aMPUP3nNAEBGF21hAqcDhn/ZBXipSacgq1rZ+9rKuvq7YGOc4uFyEhmVdAX3htv/ ixEGHXrrxpwfLwkRXSavmn8Kt5DCJQOt17xJhzHWGt7IWKnKlcglcnbeB5VMH3m6QL4M ASZA==
List-archive: <https://archive.midrange.com/rpg400-l/>
List-help: <mailto:rpg400-l-request@lists.midrange.com?subject=help>
List-id: "RPG programming on the IBM i \(AS/400 and iSeries\)" <rpg400-l.lists.midrange.com>
List-post: <mailto:rpg400-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=unsubscribe>

<Charles>
ArdGate isn't an option as I don't have direct access to the other DB...
</Charles>

this wouldn't be the real problem, as we decoupled the trigger layer from the replication to work around silly restrictions of DB2/400 (you can't connect to a remote database inside a trigger or down the call stack of a trigger and 3 part alias is limited too) trigger sends to dataq and listener makes the replication. It wouldn't be too hard to replace the remote sql stuff by your REST call.

The benefit for the trigger way is, that the black box application stays untouched - but you can't redirect reads doing it this way.

Dieter

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.