RE: Copy multiple files to PC csv format -- MIDRANGE-L


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 havethe iSeries navigator.I tried FTP, but can't get that going on AS400, it can't log on to a PCeven though user and password exits on the domain and is administrator.Sorry to keep bothering everyone here, the problem is we've moved to Unixand I'm the only AS400 application developer left, we have no AS400 supportanymore so I have to figure out how to get our database at least to a PCenvironment.

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