Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Slightly OT: Capturing a failed status of an ftp process

Re: Slightly OT: Capturing a failed status of an ftp process

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Tue, 03 Apr 2001 13:30:03 -0700
Message-ID: <F001.002E0721.20010403133626@fatcity.com>

Would it be possible for you to send me a copy of how you are using the status command? I have tried, but I am obviously doing it wrong, as I am not getting what I expect.

Terry

Shari Dishop wrote:

> 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terry Ball
  INET: terry_ball_at_csgsystems.com

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: ListGuru_at_fatcity.com (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).
Received on Tue Apr 03 2001 - 15:30:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US