That strikes me as by far and away the best answer Chuck.

Using a tool like AppServer4RPG with the packaged ArdGate (all free would allow them to simply write directly to the target database files from their RPG code just using embedded SQL. Got to be a hell of a lot easier than playing games with CSVs, FTP, or whatever. One RPG or COBOL program processes the data and voila it is all there on the target system

Jon Paris

On Feb 13, 2015, at 3:07 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

On 13-Feb-2015 13:43 -0600, Grizzly Malchow wrote:
Can you use NFS, or QNTC to connect to the Windows server? If so,
what would prevent you from using CL, RPG, or COBOL to access the
files on the Windows server and do all of the read/write stuff in
said languages?

Maybe there is more to it that I understand but you could definitely
read the files and write the files if you can connect via a file
share. To me that would alleviate the overhead of doing HTTP
requests to move the files around.

With a share, from an IBI i programming standpoint, the files would
be part of the IFS.

Or perhaps eliminate the IFS\shares entirely, because the scenarios from the OP refer to the use of both database export and database import capabilities. Thus presumably, the data on the separate servers would have been exported-from and imported-into their respective databases as the final stage of the /transfer/.?

And if that is the case, then perhaps just use some form of database connectivity to access the data from wherever the data resides in a RDBMS, or effect the replication perhaps even replicated as full replacement of the data, to mimic the described copy\transfer while having eliminated any export\import activity that requires intermediate copies of the database data in textual format?

Regards, Chuck
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

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