In defense of those who suggested database connectivity as opposed to file
transfers, that would make CPYFRIMPF and CPYTOIMPF steps unnecessary.

On the other hand, file transfer may be justified for security purposes. Or
maybe you need to implement procedures for exception handling and recovery,
where code should run on the target server.

At any rate, HTTPAPI and GETURI are good tools for implementing HTTP file
transfers. I'm not aware of any better.

Nathan.


On Fri, Feb 13, 2015 at 3:31 PM, Kelly Cookson <KCookson@xxxxxxxxxxxx>
wrote:

Again, there are lots of ways to transfer data across systems, including
eliminating the stream files and doing direct database connections. Our DBA
already writes scripts to transfer data between the IBM i DB2/400 database
and a Microsoft SQL Server database.

We have also had success using FTP to move files between the IBM i IFS and
a Windows server running PeopleSoft. I used JTOpen to develop Java classes
that remotely use the IBM i FTP server. We then write PeopleCode in
application engine programs that call the Java classes. I developed the
Java classes in 2006, and we have had virtually no problems in 9 years.
(BTW--we could have used the JTOpen classes directly in PeopleCode. My Java
classes just served as wrappers to the JTOpen classes, thereby reducing the
number of lines of PeopleCode we had to write.)

I am here wanting to learn how to transfer files between the IBM i and
other servers using HTTP\HTTPS. I am not suggesting HTTP\HTTPS is the best
way of doing file transfers; I am not suggesting that HTTP\HTTPS would ever
become our primary way of doing file transfers. I am just exploring the
possibilities of a tried-and-true protocol to transfer files across a
TCP/IP network.

Thanks,
Kelly

-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Friday, February 13, 2015 3:16 PM
To: Web400@Midrange. Web400
Subject: Re: [WEB400] Using HTTP\HTTPS to Transfer Files Between Servers?

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

Using a tool like AppServer4RPG with the packaged ArdGate (all free
http://sourceforge.net/projects/appserver4rpg/) 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

www.partner400.com
www.SystemiDeveloper.com

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,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.


--
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,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.

--
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,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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