Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Executing remote procedures...

2 posts in Windows NT Last posting was on 1997-08-14 18:47:25.0Z
CIBERNETICA, S.A. Posted on 1997-07-29 07:58:09.0Z
Message-ID: <33DDA291.FF@pty.com>
Date: Tue, 29 Jul 1997 07:58:09 +0000
From: "CIBERNETICA, S.A." <cibernet@pty.com>
Reply-To: cibernet@pty.com
Organization: CIBERNETICA, S.A.
X-Mailer: Mozilla 3.01Gold (Win95; I)
MIME-Version: 1.0
Subject: Executing remote procedures...
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 9
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5582
Article PK: 1081659

I´m executing a remote procedure from a local stored procedure, if the
remote server is available there´s no problem, the thing is when the
remote server is off, i don´t receive any status and the local stored
procedured cancel its execution.

How do i solve this problem?

Thanks in advance for your assistance!

Julio


Mike Meek Posted on 1997-08-14 18:47:25.0Z
Message-ID: <33F352BD.6E82@sybase.com>
Date: Thu, 14 Aug 1997 11:47:25 -0700
From: Mike Meek <mmeek@sybase.com>
Organization: Sybase Inc.
X-Mailer: Mozilla 2.02 (WinNT; I)
MIME-Version: 1.0
Subject: Re: Executing remote procedures...
References: <33DDA291.FF@pty.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 15
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5576
Article PK: 1081652

One method would be to have a small table
rpc_table( rpc_date datetime) that the local
procedure reads for the last entry. The RPC on the
remote server as its last action, executes an RPC
back to the source server which updates the
rpc_table table with the current date and time.
Your local proc would do a waitfor until enough
time has passed for the 1st RPC to have completed
and compares the current rpc_date value with the
one it read at the start of the local proc.

Be sure to have an entry in the rpc_table before
you start.

Mike Meek
Sybase Alliance