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.

Interrupting a long query

3 posts in General Discussion Last posting was on 2003-09-17 09:37:14.0Z
philb Posted on 2003-09-16 14:24:12.0Z
Sender: 2f4d.3f671c73.1804289383@sybase.com
From: philb
Newsgroups: ianywhere.public.general
Subject: Interrupting a long query
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f671d0c.2f61.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Sep 2003 07:24:12 -0700
X-Trace: forums-1-dub 1063722252 10.22.241.41 (16 Sep 2003 07:24:12 -0700)
X-Original-Trace: 16 Sep 2003 07:24:12 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1757
Article PK: 4048

In ISQL you can interrupt a query that is running too long
by just pressing a button.

Is there a generalized method to interrupt a query, or is
this just some special feature ISQL has?

It would be nice to stop an errant query without having to
result to extreme killing measures.


Serge Gavrilov Posted on 2003-09-17 08:47:33.0Z
Message-ID: <3F681ECD.3010503@mail.ru>
From: Serge Gavrilov <sergegavrilov@mail.ru>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Interrupting a long query
References: <3f671d0c.2f61.846930886@sybase.com>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: ip204178.seaport.spb.ru
X-Original-Trace: 17 Sep 2003 01:49:38 -0700, ip204178.seaport.spb.ru
Lines: 9
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Sep 2003 01:44:04 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Sep 2003 01:47:33 -0700
X-Trace: forums-1-dub 1063788453 10.22.108.75 (17 Sep 2003 01:47:33 -0700)
X-Original-Trace: 17 Sep 2003 01:47:33 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1762
Article PK: 4062

In embeded SQL You can use function db_cancel_request. If You are
developer on Delphi use SaVcl - VCL for direct access to Sybase
Anywhere. Component TSaDb has method CancelRequest. Also You can cancel
request from event handler TSaDb.OnWait that called when a long query is
executed on the server. SaVcl can be downloaded from
http://savcl.narod.ru/eh.html

Best regards, Serge Gavrilov.


Serge Gavrilov Posted on 2003-09-17 09:37:14.0Z
Message-ID: <3F682A71.6020301@mail.ru>
From: Serge Gavrilov <sergegavrilov@mail.ru>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Interrupting a long query
References: <3f671d0c.2f61.846930886@sybase.com> <3F681ECD.3010503@mail.ru>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: ip204178.seaport.spb.ru
X-Original-Trace: 17 Sep 2003 02:39:18 -0700, ip204178.seaport.spb.ru
Lines: 6
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Sep 2003 02:33:44 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Sep 2003 02:37:14 -0700
X-Trace: forums-1-dub 1063791434 10.22.108.75 (17 Sep 2003 02:37:14 -0700)
X-Original-Trace: 17 Sep 2003 02:37:14 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1763
Article PK: 4061

Sorry!

SaVcl can be downloaded from http://savcl.narod.ru/en.html

Best regards, Serge Gavrilov.