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.

Data Locking in ianywhere

2 posts in General Discussion Last posting was on 2008-09-08 13:56:55.0Z
Aida Posted on 2008-09-08 13:22:33.0Z
From: "Aida" <aida_abouzeid@ipsos-stat.com>
Newsgroups: ianywhere.public.answersanywhere.general
Subject: Data Locking in ianywhere
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48c52719@forums-1-dub>
Date: 8 Sep 2008 06:22:33 -0700
X-Trace: forums-1-dub 1220880153 10.22.241.152 (8 Sep 2008 06:22:33 -0700)
X-Original-Trace: 8 Sep 2008 06:22:33 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.answersanywhere.general:142
Article PK: 3258

Hi,
I'm uisng ASA9 and I'm facing the following problem:
Some commands deletion sent to the database by a batch process could not be
executed successfully, even though the data to be deleted has no related
data ; so it's not a matter of referential integrity.
My question is : does ianywhere perform any kind of locking on the data that
may deny the order deletion sent , knowing that some processes that maybe
running in parallel with the deletion process are using CURSORS ?

Note that it'sot a matter of access rights or security becuase many other
similar commands are successfully executed...

Thanks in advance !


"Stephen Rice" Posted on 2008-09-08 13:56:55.0Z
From: "Stephen Rice" <srice[at]sybase[dot]com>
Newsgroups: ianywhere.public.answersanywhere.general
References: <48c52719@forums-1-dub>
Subject: Re: Data Locking in ianywhere
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48c52f27$1@forums-1-dub>
Date: 8 Sep 2008 06:56:55 -0700
X-Trace: forums-1-dub 1220882215 10.22.241.152 (8 Sep 2008 06:56:55 -0700)
X-Original-Trace: 8 Sep 2008 06:56:55 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.answersanywhere.general:143
Article PK: 4050

Hi

1) You should be posting in sybase.public.sqlanywhere.general. This group
is used for our Answers Anywhere product (if you are into natural languages
should look at it)

2) Yes SQL Anywhere does all sorts of locking to ensure concurrency. There
is not enough information in your post to be able to be much help. In the
other newsgroup, please describe exactly what is going on, what "not be
executed successfully" means. There will probably be lots of questions
about your post but I expect it will get figured out.

--
/steve
Stephen Rice, Sybase iAnywhere
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"Aida" <aida_abouzeid@ipsos-stat.com> wrote in message
news:48c52719@forums-1-dub...
> Hi,
> I'm uisng ASA9 and I'm facing the following problem:
> Some commands deletion sent to the database by a batch process could not
> be executed successfully, even though the data to be deleted has no
> related data ; so it's not a matter of referential integrity.
> My question is : does ianywhere perform any kind of locking on the data
> that may deny the order deletion sent , knowing that some processes that
> maybe running in parallel with the deletion process are using CURSORS ?
>
> Note that it'sot a matter of access rights or security becuase many other
> similar commands are successfully executed...
>
> Thanks in advance !
>