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

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 08:07:12 +0100
Arc-authentication-results: i=1; mx.google.com; spf=neutral (google.com: 212.227.126.135 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=66bqkWTqHLBKZxp2aOUFEqFRi4s4IOu+ctvRyMoWYs8=; b=dyn0UnC9GSCy+M8m6YW/E/6u8HYTTLxQ9tEYs+nSGQpaeRTUnXBIjcH+fy5mr8ypK+ M7ljiIx4Zqq7kj3P66FU1hQeIoZPq4x9pjy8eyxgIxiI4tbBpBIXRpkDn80HUgZuDY5k 3j8KRFhP2WwdkkjL3S3b16og9wl9Kh2zPQALi1j3Xvp3y5Uu/GKD6ZvWZGwXiwUhpKFM iSPttLJYf2jSJeV2jUFJlS9TompZTdMYudjB07XCkDQfLdG9MOjzXz/YC+QbMo3NqaqL KVcSJXcp1lHt7o1eJO4G/3gjH9/Vxv7jrZPcwgrFia+YTVZ/wOpquUrS2rOHSfHvlXuh V1Iw==
Arc-seal: i=1; a=rsa-sha256; t=1547536021; cv=none; d=google.com; s=arc-20160816; b=OamfcyggNEP5UIsHV6mug09vMCljrd1JBJ/zyo18iTWh0lw0MfJtVHwTMLJynPdfDY GY4gUPWHCbaxFh1YmNZjMjb5pHGMe8S7RNdkk7kWk9LU5f06DcsT1ChBpuTKvr3J+QM7 cBXkvQK6ODNiam1Ak+ZcYxW3bIJWd5B4aQGeNF/md0WoR0m5QQAc9bLZ9sRjbE7NCTC8 9l9DI0lncWC6wdhwUtZA2zYSPkigNl+J45s0xwX2Qcd3KXTkJ0g3E5+SP/6gJkICIXoz es2yYT02gdngM3dnCMPhfhX0S4DIiT/TYDK42NZm2itxuZu3bVIpaqO+QaHw+9J1kSpD Eo5g==
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,

having a requirement to redirect reads and writes to another box, coming from a black-box-software, I was thinking about OA too:
- to minimize impact the OA should be externalized
- having multiple logical files duplicates handlers
- having multiple opens to the same file in one job SRVPGMs can't be used, instead bind module by copy
- having OVRDBF complexity will grow
- having share *YES it's getting complicated
After the first analysis summing up the effort, the requirement was modified and we used triggers to replicate via ArdGate to the remote box.

Dieter

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Writing an Open Access handle that will either read/write to the Db2 file or make a REST call , Charles Wilt
Re: Writing an Open Access handle that will either read/write to the Db2 file or make a REST call , Jon Paris

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.