RE: Copy multiple files to PC csv format

Don't transfer the file in binary mode. Let the automatic EBCDIC to
ASCII conversion happen.

> -------- 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
> 
> 
> 
> >Rob Berendt
> >--
> >Group Dekko Services, LLC
> >Dept 01.073
> >PO Box 2000
> >Dock 108
> >6928N 400E
> >Kendallville, IN 46755
> >http://www.dekko.com
> >
> >
> >
> >
> >
> >"Anne d'Hooge" <a.dhooge@xxxxxxxxxx>
> >Sent by: midrange-l-bounces@xxxxxxxxxxxx
> >02/02/2006 11:39 AM
> >Please respond to
> >Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> >
> >
> >To
> >midrange-l@xxxxxxxxxxxx
> >cc
> >
> >Fax to
> >
> >Subject
> >RE: Copy multiple files to PC csv format
> >
> >
> >
> >
> >
> >
> >
> > >
> > >
> > >date: Thu, 2 Feb 2006 11:08:36 -0500
> > >from: "Mark Walter" <mwalter@xxxxxxxxxxx>
> > >subject: RE: Copy multiple files to PC csv format
> > >
> > >Which version of the OS are you on?
> >
> >V4R5M0
> >
> >Anne
> >
> >
> >
> > >Mark Walter
> > >Senior Programmer/Analyst
> > >IBM Certified RPG Developer
> > >Hainey Business Systems
> > >(717) 771-2362
> > >mwalter@xxxxxxxxxxx
> > >http://www.hbs-inc.com
> > >
> > >
> > >message: 8
> > >date: Thu, 2 Feb 2006 11:14:55 -0500
> > >from: rob@xxxxxxxxx
> > >subject: RE: Copy multiple files to PC csv format
> > >
> > >What version of i5/os are you running?
> >
> >
> >V4R5M0
> >
> >
> > >Are you using CPYTOPCD or the CPYTOIMPF?
> >
> >CPYTOIMPF
> >
> >
> > >Did you set up NetServer?
> > >http://faq.midrange.com/data/cache/68.html
> > >
> > >Did you use iSeries Navigator to add a "share"?
> > >File Systems, Integrated File Systems, root, right click on desired
> > >directory, select Sharing.
> >
> >How do I go to root ? I started from the main menu, General system
> >tasks,Files,Intergrated File System.. there I have 1.Directory commands,2.
> >
> >object commands,3.security commands.
> >Under directory commands I can create, remove a directory, change or
> >display current directory. How do I view the root ?
> >
> >Anne
> >
> >
> > >Rob Berendt
> > >--
> > >Group Dekko Services, LLC
> > >Dept 01.073
> > >PO Box 2000
> > >Dock 108
> > >6928N 400E
> > >Kendallville, IN 46755
> > >http://www.dekko.com
> > >
> > >
> > >
> > >
> 
> -- 
> 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.