Midrange News for the IBM i Community


Posted by: Noel Manley
Transfer Data from the IFS of one iSeries to Another
has no ratings.
Published: 22 Aug 2012
Revised: 23 Jan 2013 - 3713 days ago
Last viewed on: 20 Mar 2023 (7670 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Transfer Data from the IFS of one iSeries to Another Published by: Noel Manley on 22 Aug 2012 view comments(3)

Is it possible to convert a Spool file to a .txt file one iSeries and then transfer it to the IFS of another iSeries without using FTP?  Thanks.  

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: DaleB
Premium member *
Reading, PA
Comment on: Transfer Data from the IFS of one iSeries to Another
Posted: 10 years 7 months 3 days 1 hours 55 minutes ago
Edited: Wed, 22 Aug, 2012 at 20:18:06 (3867 days ago)

Can you convert a spool file to .txt file? Yes. (Do you need to be able to recover it as a spooled file on the remote server? Or is lines of text good enough?)

Can you transfer an IFS file between IBM i servers without using FTP? Sure. SNADS, e-mail (SNDDST or MIME API), make a share available on one server and MKDIR in \QNTC on the other after which it's just a CPY or equivalent, NFS mount, SAVRST *CMD (if you have ObjectConnect installed), ...

Posted by: bobcozzi
Site Admin ****
Chicagoland
www.cozTools.com/qryfile
Comment on: Transfer Data from the IFS of one iSeries to Another
Posted: 10 years 7 months 2 days 14 hours 15 minutes ago
Edited: Fri, 02 Nov, 2012 at 09:59:41 (3795 days ago)

If you convert the SPOOL file to "text" using CPYSPLF to an outfile, you can then copy that file using DDM to another system. For example, if you create your file on system A and another file on system B with the same size/definition, you can use CPYF to copy it over.

But what is your real goal? Do you want to move the SPOOL file to another system's IFS location in text format for other apps to use it, such as Excel?

If you simply want to move the original SPOOL file so people can re-print it on the other IBM i system, then you should use the SNDPRTF command in COZTOOLS or use IBM's SNDTCPSPLF command, but read the articles on SNDTCPSPLF on this site first.

Posted by: clbirk
Premium member *
Comment on: Transfer Data from the IFS of one iSeries to Another
Posted: 10 years 7 months 2 days 14 hours 10 minutes ago

If this is not some reoccuring event (or even if it is), you can copy/paste them with inavigator, if inav has access to both machines.