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 - 1765 days ago
Last viewed on: 23 Nov 2017 (4590 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: 5 years 3 months 2 days 18 hours ago
Edited: Wed, 22 Aug, 2012 at 20:18:06 (1919 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
Comment on: Transfer Data from the IFS of one iSeries to Another
Posted: 5 years 3 months 2 days 6 hours 20 minutes ago
Edited: Fri, 02 Nov, 2012 at 09:59:41 (1847 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: 5 years 3 months 2 days 6 hours 16 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.