RE: Multiple CA downloads

[Scott Mildenberger <Smildenber@xxxxxxxxxxxx>]

Sam,
        You could do a CPYTOIMPF (if on V4R2 or later) to another temp file
and then ftp those temp files.  Or you could do a CPYTOPCD from the DB2 file
to a text file in a folder.  The PC could have a drive mapped to the folder
and read the files directly from there.  We have a totally automated process
that goes the opposite direction.  The PC saves text files on a drive mapped
to a folder and a job on the 400 reads those files and updates PF's
accordingly.

Scott Mildenberger

> -----Original Message-----
> From: Sam Kanakanui [SMTP:kanakanuis@mindspring.com]
> Sent: Thursday, December 16, 1999 8:02 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      RE: Multiple CA downloads
> 
> The files are DB2 files on the AS/400.  They need to go to a PC based
> package that needs to read them in ASCII format.  I thought that I needed
> to
> use an ODBC tool like CA to translate them going down.  I don't think I
> can
> just FTP them, the PC package would not read them.  Any other ideas, lief?
> 
> -----Original Message-----
> From: owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]
> On Behalf Of leif@attglobal.net
> Sent: Thursday, December 16, 1999 9:06 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: Multiple CA downloads
> 
> > I have a need to download about 50 files together.  I need to convert
> them
> > to ASCI
> 
> If they are already in EBCDIC text format (i.e. does not contain any
> packed
> decimal or binary data), you could FTP the files down to your PC. You can
> write a script to control the FTP process (if you have to download the
> files
> several times).
> 
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---