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 - 1852 days ago
Last viewed on: 18 Feb 2018 (4851 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)

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 5 months 28 days 21 hours 58 minutes ago
Edited: Wed, 22 Aug, 2012 at 20:18:06 (2006 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 5 months 28 days 10 hours 18 minutes ago
Edited: Fri, 02 Nov, 2012 at 09:59:41 (1934 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 5 months 28 days 10 hours 13 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.