Re: Win2K Pro FTP server recommendations -- MIDRANGE-L

If you have client access express, you can pull files from the AS/400 to the
PC via command line.  I have a code example of doing it via batch file that
I use.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Paul Raulerson" <praulerson@hot.rr.com>
To: <midrange-l@midrange.com>
Sent: Sunday, December 15, 2002 9:17 PM
Subject: Re: Win2K Pro FTP server recommendations


> Not at all. I initiate batch files on a PC from various hosts (i.e.
Mainfames, AS/400's, and even Wangs :) all the time, and simply
> script the batch file on the PC side. Drop me a note offline and I'll pass
you some samples of what I do - remember though I try to
> keep the whole process very simple!! You can make it
> far more complex if you wish.
> -Paul
>
> Paul.Raulerson@citizensinc.com
>
> ----- Original Message -----
> From: "Ian Scotson" <iscotson@bigpond.com>
> To: <midrange-l@midrange.com>
> Sent: Sunday, December 15, 2002 5:01 PM
> Subject: RE: Win2K Pro FTP server recommendations
>
>
> > Im all for making things as simple and trouble free as possible.
> > Thats one of the reasons im looking at FTP in the 1st place.
> >
> > The PC application needs a CSV formated file.
> >
> > Im assuming what your saying is to use the FTP server on the AS400,
> > and the FTP client from the Win2K box. Pull rather than Push.
> >
> > I guess the reason i was looking at Push was i know i can control the
> > entire process from CL, and have it all done on the one machine.
> >
> > I cant expect the user to learn FTP cmds, and i dont know off-hand how
to write
> > an FTP script that can run on a Win2K Pro box. Or can that be done in
some
> > of the FTP clients like WS-FTP?
> >
> > Also, currently the PC code would like to do a RMTCMD to do at least a
> > CLRPFM, an my preference is to do all of that natively. The more done on
a
> > single box the better to my mind.
> >
> >
> > Still,
> >
> > Pulling the data could still be a viable solution - either way someone
has to
> > manually initiate the process - the same person that starts off the
following
> > PC application.
> >
> > Something to think about.
> > Interesting how you often tend to focus on the solution you 1st think
of.
> >
> > "If all you have is a hammer, everything looks like a nail"
> >
> >
> > Thks for the suggestion.
> >
> > Regards
> >
> > Ian.
> >
> >
> >
> > -----Original Message-----
> > From: Paul Raulerson [SMTP:praulerson@hot.rr.com]
> > Sent: Monday, 16 December 2002 2:08
> > To: midrange-l@midrange.com
> > Subject: Re: Win2K Pro FTP  server recommendations
> >
> > I'll show my ignorance;
> >
> >    Why don't you just have the W2K machine FTP the file down as a
flatfile, or as a comma separate file
> > if that is what you really need?  I do this on a pretty regular basis
here. It sounds like you are making a pretty simple task
> much
> > more difficult that it really has to be...
> >
> > -Paul
> >
> >
> > ----- Original Message -----
> > From: "Ian Scotson" <iscotson@bigpond.com>
> > To: <midrange-l@midrange.com>
> > Sent: Sunday, December 15, 2002 12:31 AM
> > Subject: Win2K Pro FTP server recommendations
> >
> >
> > >
> > > Hi guys,
> > >
> > > I'm looking at a job that needs to transfer a CSV file from
> > > a DB400 file to a Win2K pro PC for eventual sending to
> > > a number of Retail stores via s/ware on the Win2K Pro PC.
> > >
> > > It has been currently done via ODBC into access, then moved
> > > via a Mapped drive method - very messy to me and damn
> > > slow  - mainly im told because a RMTCMD wouldnt work
> > > because of Conflicting OCX type problems?
> > >
> > > Anyway, my feeling is that doing all conversion work to CSV on the
> > > AS400 (V5R1) via CPYTOIMPF with maybe a little help from
> > > a bit of freeware (CRTCSVDTA) courtesy of Martin Rowe, and then
> > > FTP'g it to the PC would be the better/cleaner/quicker/etc way to
> > > go.
> > >
> > > Having said that, what FTP server on the Win2K should i use??
> > > I believe Win2K Pro has it own FTP server - would that work OK?
> > > If so, is it easy to setup and get working?Reliable?
> > > Or maybe some other freeware/shareware product?
> > > Probably cant justify a full blown commercial product ( other than
pretty cheap one..)
> > >
> > > Any recommendations that work well with the AS400 would be most
welcome.
> > >
> > > Regards
> > >
> > >
> > > Ian Scotson.
> > >
> > > _______________________________________________
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> > > To post a message email: MIDRANGE-L@midrange.com
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@midrange.com
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> > >
> > >
> >
> >
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.