Updating sas table with multiple updates from different users

[jerry898969]

Hello everyone,

I'm about to start a project that is a windows forms front end with c# in the code behind and sas as the back end.   My question is if i'm using oledb can multiple users do an update, insert or delete on the same table at the same time?

Thank you

[Haikuo]

Do you have SAS/SHARE?

[jerry898969]

Hi Hai,

Thank you for your reply.  Yes we are using a SAS/SHARE.

Thank you

[LinusH]

I sugest that you resd the SHARE documentation.  It will allow concurrent reads and updates,  but not entirely the same way as a RDBMS.

[SASKiwi]

If you are using SAS/SHARE with SAS datasets then OLEDB would not be necessary.

[jerry898969]

Hi LinusH,

Sorry for my delayed response but I ready the SHARE documentation and I didn't fully understand it.  Do I need to handle the row locks myself?

I looked at Chapter 5 Locking SAS Data Objects and I understand the locking portion.  I want to make sure that is the correct way to go about doing it.

Thank you again for any help

[SASKiwi]

The way I read it SAS/SHARE provides a default set of rules for locking SAS data depending on how you are accessing it. However you can override these rules by applying locks explicity with the LOCK statement/command. However that's just my take on the doc, not having used SHARE myself. Best to get other opinions from those who actually use it.

[Patrick]

I've used SAS/Share in the past. You can select if you want a table lock or a row level lock. I would assume you normally would want row level locking.

Yes, you can have several processes with write access on row level. That's what SAS/Share is for.

Be aware that SAS/Share is single threaded so there could be some performance issues if you're having lots of users accessing at the same time. I try normally to use a DBMS if I need concurrent write access (or read/write at the same time).

I strongly prefer using SAS/Share for small tables only like control tables and the like - but we don't have always the luxury of choice....