BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
CHUNantes
Obsidian | Level 7

Hello.

 

We have two jobs that can run in parallel some times.

 

One job (A) will update a table and one job (B)  just need to read the table.

 

So to avoid lock, job B use this statement :

 

LIBNAME r_thfcs "path_to_data" ACCESS=READONLY;

PROC SQL;
   CREATE TABLE work.toto AS
   SELECT *
   FROM work.titi,
        r_thfcs.tutu
   ;
QUIT;

But today, when job A run and try to update r_thfcs.tutu table, a lock was held by Job B !

 

Does it means PROC SQL is over READONLY access ?

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20

A READ lock is still a lock, if your other process need to update the table.

If you need concurrent read and qrites on the same table you need to use either SAS/SHARE, SAS SPD Server or an external RDBMS.

Another option is to schedule your jobs so thay don't access the table at the same time.

Data never sleeps

View solution in original post

1 REPLY 1
LinusH
Tourmaline | Level 20

A READ lock is still a lock, if your other process need to update the table.

If you need concurrent read and qrites on the same table you need to use either SAS/SHARE, SAS SPD Server or an external RDBMS.

Another option is to schedule your jobs so thay don't access the table at the same time.

Data never sleeps

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 338 views
  • 0 likes
  • 2 in conversation