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.

Is it possible to lock a table ?

3 posts in Windows NT Last posting was on 2000-11-05 11:53:37.0Z
Jim Demchuk Posted on 2000-11-04 14:39:44.0Z
From: "Jim Demchuk" <jdemchuk@hotmail.com>
Subject: Is it possible to lock a table ?
Date: Sat, 4 Nov 2000 09:39:44 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <S84657mRAHA.275@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: HSE-Toronto-ppp170589.sympatico.ca 64.229.54.52
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1518
Article PK: 1088996

I was wondering if it is possible to 'lock' a table so that
it is in single user mode ?

I have thought of having the application write a 'flag' to
a common directory so if a second user tries to run the
app, they would get a message returned to them telling
them to try again later etc... However, if the first users PC
crashed or was shutdown , the flag would not be removed
without manual intervention.

(Note: the application uses straight ODBC to access ASE 11.9.2)

Thanks

Jim


Anonymous Posted on 2000-11-04 17:47:16.0Z
From: Anonymous@sybase.com
Date: Sat, 4 Nov 2000 12:47:16 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: Is it possible to lock a table ?
Message-ID: <BC24DF4DFF0DB5C80061B6588525698D.0052F8938525698D@webforums>
References: <S84657mRAHA.275@forums.sybase.com>
Lines: 3
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1517
Article PK: 1088990

In your transaction, you may be able to lock a table explicitly.
If so, it has the same implication. Since one user at any given
time can access the table.


Rob Verschoor Posted on 2000-11-05 11:53:37.0Z
Reply-To: "Rob Verschoor" <rob@sypron.nl>
From: "Rob Verschoor" <rob@sypron.nl>
References: <S84657mRAHA.275@forums.sybase.com>
Subject: Re: Is it possible to lock a table ?
Date: Sun, 5 Nov 2000 12:53:37 +0100
Lines: 43
Organization: Sypron B.V.
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <ViMxNDyRAHA.162@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: i0284.pvu.euronet.nl 194.134.165.29
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1515
Article PK: 1089006

You can use the "lock table" command for this. The syntax and
description are included in the ASE Quick Reference Guide Supplement,
which you can download from http://www.sypron.nl/ase_qref.html .

HTH,

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:rob@sypron.nl.*No*Spam*Please*
WWW http://www.sypron.nl
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

"Jim Demchuk" <jdemchuk@hotmail.com> wrote in message
news:S84657mRAHA.275@forums.sybase.com...
> I was wondering if it is possible to 'lock' a table so that
> it is in single user mode ?
>
> I have thought of having the application write a 'flag' to
> a common directory so if a second user tries to run the
> app, they would get a message returned to them telling
> them to try again later etc... However, if the first users PC
> crashed or was shutdown , the flag would not be removed
> without manual intervention.
>
> (Note: the application uses straight ODBC to access ASE 11.9.2)
>
> Thanks
>
> Jim
>
>
>
>
>