• 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

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].