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

Ian

Here's a way to do all that from the PC

Put the following into a .bat file named install.bat in directory c:\xcba:

rem Syntax: c:\xcba\install system user password
rem
rem Changes to the directory where, in this case, the save file image is
cd c:\xcba

rem Put the user ID into the script
echo %2 > install.ftp

rem Put the password into the script
echo %3 >> install.ftp

rem Set up NAMEFMT 1 (path naming)
echo quote site nam 1 >> install.ftp

rem Set binary transfer type
echo bin >> install.ftp

rem Create a library on the iSeries
echo quote rcmd crtlib lib(xcba) aut(*all) >> install.ftp

rem Send the save file image - SAVF is created automatically (not as
physical file)
echo put xcba.savf /qsys.lib/xcba.lib/xcba.savf >> install.ftp

rem Restore the library
echo quote rcmd rstobj obj(*all) savlib(xcba) dev(*savf) savf(xcba/xcba)
mbropt(*all) alwobjdif(*all) rstlib(xcba) >> install.ftp

rem End the FTP session
echo quit >> install.ftp

rem Run the FTP script
ftp -s:install.ftp %1

rem Delete the script - password is in the clear in script, so get rid of it
del install.ftp

Main issue is password is in the clear. Putting it in a scheduler would
leave that password visible all the time.

There COULD be an anonymous access to the iSeries, but there could
(should?) be limitations.

HTH

Vern

At 10:01 AM 12/16/2002 +1100, you wrote:

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.