Date:         Mon, 31 Jan 2000 14:47:05 GMT
Reply-To:     charles_s_patridge@MY-DEJA.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         charles_s_patridge@MY-DEJA.COM
Organization: Deja.com - Before you buy.
Subject:      Re: Question about data-sharing

Dear Ken,

As I understand data-sharing in SAS here it is:

1.  Any number of sas users can "read" a dataset as long as no one has
the dataset opened in "write/update mode".  This might vary across
platforms.

2.  If someone has the dataset opened in "write/update mode", then all
others are locked out from the entire dataset, or their job is held in
suspense until the SAS Dataset is released.  Again this may vary across
platforms.

If you need to have more than 1 person have write/update access to 1 SAS
dataset, then you will need the SAS/Share module in order for this to
happen.

Hope this helps.
Charles Patridge
Email: Charles_S_Patridge@prodigy.net
Web: www.sasconsig.com



In article <20000129210150.29831.00000320@ng-ck1.aol.com>,
  kenmlin@aol.com (Kenmlin) wrote:
> I have a question for all you SAS gurus.
>
> If I have a SAS table that is accessed by multiple users, what are the
> consequence of more than one user attempting to access the table
> simultaneously.  I am more accustomed to database software like MS SQL
and
> SyBase which have page-locking capabilities to address such conflict.
I notice
> that SAS creates a temporary file when a table is being modified so I
was just
> wondering what takes place in the background.
>
> Ken
>
>

--
Charles Patridge - PDPC, Ltd.
172 Monce Road - Burlington, CT 06013
860-673-9278 or 860-675-9026
Charles_S_Patridge@prodigy.net  www.sasconsig.com


Sent via Deja.com http://www.deja.com/
Before you buy.