RE: Copy multiple files to PC csv format

I FTP files using the DOS command prompt from the AS/400 to the PC all
the time, and it does the EBCDIC to ASCII conversion automatically. Try
entering the command manually rather than in a script - maybe that will
show the error message better. You might also want to use a different
extension on the file name - see if that makes a difference.

> -------- Original Message --------
> Subject: RE: Copy multiple files to PC csv format
> From: "Anne d'Hooge" <a.dhooge@xxxxxxxxxx>
> Date: Fri, February 03, 2006 9:41 am
> To: midrange-l@xxxxxxxxxxxx
> 
> >
> >date: Fri, 03 Feb 2006 07:20:27 -0700
> >from: michael@xxxxxxxxxxxxxxxxxx
> >subject: RE: Copy multiple files to PC csv format
> >
> >Don't transfer the file in binary mode. Let the automatic EBCDIC to
> >ASCII conversion happen.
> 
> That would be possible if I FTP'd from AS400, but that doesn't work, so I'm 
> working from DOS. The DOS script gives an error if I don't us bin (binary 
> required).
> 
> > > -------- Original Message --------
> > > Subject: RE: Copy multiple files to PC csv format
> > > From: "Anne d'Hooge" <a.dhooge@xxxxxxxxxx>
> > > Date: Fri, February 03, 2006 9:18 am
> > > To: midrange-l@xxxxxxxxxxxx
> > >
> > > >
> > > >date: Thu, 2 Feb 2006 12:37:31 -0500
> > > >from: rob@xxxxxxxxx
> > > >subject: RE: Copy multiple files to PC csv format
> > > >
> > > >It's been YEARS since I've used that version of iSeries Access.  I sent
> > > >you a screen shot of what I'm talking about offlist.
> > >
> > >
> > > Rob,
> > >
> > > Thank you for the screen shot, I've never seen that before. We don't have
> > > the iSeries navigator.
> > > I tried FTP, but can't get that going on AS400, it can't log on to a PC
> > > even though user and password exits on the domain and is administrator.
> > > Sorry to keep bothering everyone here, the problem is we've moved to Unix
> > > and I'm the only AS400 application developer left, we have no AS400 
> > support
> > > anymore so I have to figure out how to get our database at least to a PC
> > > environment.
> > > I can get FTP started from DOS with script :
> > > open (AS400 IP)
> > > user id
> > > passw
> > > cd /QDLS/ANNE
> > > dir
> > > bin
> > > get file.csv
> > > bye
> > >
> > > I does transfer the file,but the data is gibberish.
> > > The file is copied to QDLS with CPYTOIMPF as discussed earlier.
> > > If I do a DSPF /QDLS/ANNE/file.csv  on AS400 it looks ok, comma seperated.
> > >
> > > Any ideas, FTP parameters to get it transferred and we actually read it ?
> > >
> > > Thanks
> > >
> > > Anne
> > >
> >
> >date: Fri, 3 Feb 2006 08:28:26 -0600
> >from: "Grizzly Malchow" <grizzlym@xxxxxxxxxxxxxxxxxxxxx>
> >subject: RE: Copy multiple files to PC csv format
> >
> >Do you need to transfer in binary?
> 
> I'm working from DOS, tried the script without bin, then I get 'binary 
> required'.
> 
> 
> 
> >-----Original Message-----
> >From: midrange-l-bounces+grizzlym=northernwholesale.com@xxxxxxxxxxxx
> >[mailto:midrange-l-bounces+grizzlym=northernwholesale.com@xxxxxxxxxxxx]
> >On Behalf Of Anne d'Hooge
> >Sent: Friday, February 03, 2006 8:18 AM
> >To: midrange-l@xxxxxxxxxxxx
> >Subject: RE: Copy multiple files to PC csv format
> >
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.