topic Re: Lock available for SAS table in SAS Programming

Lock available for SAS table

LinusH — Thu, 29 Jan 2009 14:14:05 GMT

Hi everyone,
Does anybody know a convenient way to find out if I can get an exclusive lock on table, before a batch job is launched? We are using 9.1.3, and both Base and SPDE. Since SPDE apparently doesn't support the LOCK statement, and the OPEN function just open tables in input mode, I don't know what to do.

Thanks,

Linus

Re: Lock available for SAS table

Flip — Thu, 29 Jan 2009 14:26:15 GMT

Here is an example out of a system I am writing. It keeps trying every few seconds until it is free.

%macro update_year( fiscyear);
%if (&syserr = %sysrc(_sok)) %then %do;
%put &sysrc ;
%TRYAGAIN:
lock currbw.br_years;
%put &syslckrc;
%if (&SYSLCKRC ne %sysrc(_sok)) %then %do;
%let rc = %sysfunc(sleep(20000));

%goto TRYAGAIN;
%end;
%else %do;
CALL YOUR EXECUTION HERE;
%end;
lock currbw.br_years clear;
%end;
%else %put Status file not updated for FY &fiscyear because errcode was &syserr ;
%mend;

Re: Lock available for SAS table

LinusH — Thu, 29 Jan 2009 14:31:18 GMT

Thanks for your quick response. But SPDE does not support the LOCK statement unfortunately, so I need something else for those libraries.

/Linus

Re: Lock available for SAS table

sbb — Thu, 29 Jan 2009 20:09:19 GMT

You may want to experiment with using LIBNAME / FILENAME and interrogating automatic variables SYSFILRC or SYSLIBRC. Also the parameter WAIT=nn and the SAS OPTIONS FILEMSGS may influence SAS behavior when unsuccessful.

Scott Barry
SBBWorks, Inc.

Re: Lock available for SAS table

LinusH — Fri, 30 Jan 2009 08:08:40 GMT

Since our concern is locking on individual objects, I don't think SYSLIBRC will be useful, neither SYSFILRC (which tells whether a physical location/file exists or not). I might be helped with FILEMSGS in some way, but unfortunately we are in UNIX (Solaris), not z/os. I'm not sure how I am intend to use WAIT in this situation.

Regards,
Linus