We considered that option but we were transferring between systems with
different file structures. IBM mainframe VS. different unix VS. OpenVMS VS ...
We didn't see how to use the file size in a reliable manner.
Since one of the platforms that I was using to run my tests was an OpenVMS
system, I was even amazed when I would transfer the file to the unix SAP system
and then transfer it back to the VMS system and it wouldn't be the same size as
the original system. I ran the DIFF utility on VMS and was told that the
contents were the same but the file had a slightly different VMS block size.
Shari Dishop
SAP ABAP - Project Systems Team
Logicon - A Northrop Grumman Company
Baltimore, MD
RE:
Isn't it possible to check size of the source and remote file(s) after ftp.
If they are the same - it is a high probability that transfer was OK.
Alex Hillman
-----Original Message-----
From: Shari Dishop [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 3:52 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Slightly OT: Capturing a failed status of an
ftp process
Terry,
I worked on what I think is a similar process. We are running SAP
and need to
be able to ftp files on and off of our unix SAP servers. Someone in
the past
wrote an SAP ABAP program that does all of the set up then calls a
unix shell
script to perform the ftp. If the ftp command truely failed to
connect we had
no problem getting back a failed error message to the SAP program.
But where we
ran into some problems was when the transfer command would start but
get
interrupted for some unknown reason and never fully complete the
transfer. This
was noticed by accident one day when someone was checking a report
run off of
one of the data transfers and there were only a few hundred records
in the table
to be processed instead of a few hundred thousand.
I was then asked to come up with a solution that would look for an
unexpected
termination of the ftp connection. After lots of searching and
getting one of
our local unix gurus involved (I have worked directly on a unix
platform), we
implemented the following. It is not the best but it does seem to
be working.
We added a step to the ftp script. This step is a status command
that is
executed directly after the get or put command. This returns
information about
the ftp connection itself. It also returns a message if it is no
longer
connected. This output was passed back to the SAP program and
parsed. If I had
a message indicating that the remote host was still connected, I
assumed that
the get or put executed completely. If on the other hand I received
the message
indicating that the remote system was no longer connected I
generated an error
message from the program so that the user could check the data.
Shari Dishop
SAP ABAP - Project Systems Team
Logicon - A Northrop Grumman Company
Baltimore, MD
RE:
I think I've seen an answer to this, but I never needed it before.
If
anyone can help, I would greatly appreciate it.
We are trying to ftp files from one server to another. (Archive
logs
. . .
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shari Dishop
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
