Re: Verifying Existence of a File on a Server

You need to know the existence of a file on a server?
Why don't you use FTP to GET the file and place it in QTEMP.
Granted, if FTP fails, it doesn't necessarily mean that the file does not
exist, it does mean that there could be some other connectivity issue.
Look at this web page
 http://www.as400pro.com/servlet/sql.tipView?key=104&category=FTP
for an FTPBATCH command. I have used this at a few places for years, with
slight modifications.



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx

midrange-l-bounces@xxxxxxxxxxxx wrote on 09/07/2006 09:11:09 AM:

I am creating an association between some iSeries data and files
that reside on Windows servers.  When the file name is entered, I'd
like to verify the file exists, but I'm not sure how.  F.T.P. won't
work since it just returns the "226 - Transfer Complete" message
whether the file exists or not.  I suppose I could write a little
Visual Basic program that would update a file on the iSeries with a
code.  My instincts tell me there must be a better way though.

Any assistance will be greatly appreciated.

Donald R. Fisher, III
Project Manager
RoomStore, Inc.
(804) 784-7600 ext. 2124
dfisher@xxxxxxxxxxxxx

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