Desktop productivity for business analysts and programmers

LOCK function in SAS

Reply
New Contributor
Posts: 3

LOCK function in SAS

I'm trying to write to a table that will be used by multiple users, so I'm looking into using the LOCK function in SAS.

I read a good explanation here http://www.lexjansen.com/pharmasug/2005/posters/po33.pdf

However I found out that LOCK always returns syslckrc=0 (ie: lock was successful), even when the table is opened by somebody else. When this happens, the next error occurs when I try to insert/update a table.

Does this mean LOCK always claims a lock but doesn't actually have write access to a table? Is this a bug? If so, is there any other way I can get exclusive access to write a table?
Ask a Question
Discussion stats
  • 0 replies
  • 121 views
  • 0 likes
  • 1 in conversation