RE: Copy multiple files to PC csv format

Works for me (via WinXP FTP):

Connected to xxxxxxxx.stei.com.
220-QTCP at xxxxxxxxx.stei.com.
220 Connection will close if idle more than 5 minutes.
User (xxxxxxxx.stei.com:(none)): f_lapeyre
331 Enter password.
Password:
230 F_LAPEYRE logged on.
ftp> asc
200 Representation type is ASCII nonprint.
ftp> cd fmllib
250 "FMLLIB" is current library.
ftp> lcd c:\
Local directory now C:\.
ftp> get test test.txt
200 PORT subcommand request successful.
150 Retrieving member TEST in file TEST in library FMLLIB.
250 File transfer completed successfully.
ftp: 305 bytes received in 0.13Seconds 2.44Kbytes/sec.
ftp>quit 

                          Display Physical File Member                
 File . . . . . . :   TEST                Library  . . . . :   FMLLIB 
 Member . . . . . :   TEST                Record . . . . . :   1      
 Control  . . . . .                       Column . . . . . :   1      
 Find . . . . . . .                                                   
 *...+....1....+....2....+....3....+....4....+....5....+....          
 ***** This is a test download file...  Do NOT Process *****          
 ***** This is a test download file...  Do NOT Process *****          
 ***** This is a test download file...  Do NOT Process *****          
 ***** This is a test download file...  Do NOT Process *****          
 ***** This is a test download file...  Do NOT Process *****          
                           ****** END OF DATA ******                  

Francis Lapeyre
IS Dept. Programmer/Analyst
Stewart Enterprises, Inc.
E-mail: flapeyre@xxxxxxxx 



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Anne d'Hooge
Sent: Friday, February 3, 2006 8:41 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Copy multiple files to PC csv format 


>
>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
>