Re: Automated Batch Data Transfers from AS/400 to PC (using TTO)

> The reason we use Data Transfer is so that we can save the AS/400 database
> files as Comma Separated Value files (CSV) on the PC.  This will give us
> the option of importing these files into a Lotus Approach database during
a
> disaster recovery scenario, so that users can access key information for
> some days until an AS/400 is set up ready for us to use.
>
> So Sharing or FTPing will not work.. will it?  The data transfer is
> necessary for the data conversion we require.

In a CL program, CPYTOIMPF to create a CSV file on the AS/400, and FTP the
resulting file to the PC.  In my experience, the only way to get a truly
useful CSV from CPYTOIMPF is to create a stream file on the IFS, and use the
*CRLF record delimiter option.

For example:

CPYTOIMPF FROMFILE(MYLIB/MYFILE)
          TOSTMF('/home/paul/myfile.csv')
          MBROPT(*REPLACE)
          RCDDLM(*CRLF)

Then, in the FTP session, use the command NAMEFMT 1 before doing a PUT to
the FTP server on the PC.

Oh, and this is offtopic for the RPG list.

--
Paul


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---