topic LOCKTABLE option in DS2 porogram in SAS Programming

LOCKTABLE option in DS2 porogram

b1958 — Tue, 10 Apr 2018 12:41:33 GMT

Please see the code below. With two select statements the program seems to detect a lock conflict.

When I run it I get (among others) this message:

ERROR: BASE driver, Table TESTTBL is already in use and cannot be locked.  If you opened the file with LOCKTABLE=EXCLUSIVE, try the 
       LOCKTABLE=SHARE option

Where can I put the LOCKTABLE option in the code below? I can't figure it out.

proc ds2;
	package testpkg /overwrite=yes;
		declare package sqlstmt select1('select a from  pdsynt.testtbl') ;
		declare package sqlstmt select2('select b from  pdsynt.testtbl ');
		method testpkg();
			select1.execute();
		end;
	endpackage;
run;

data _null_;
method init();
		dcl package testpkg testpkg;
		testpkg = _NEW_  testpkg();
end;
enddata;
run;
quit;

Re: LOCKTABLE option in DS2 porogram

SuryaKiran — Tue, 10 Apr 2018 13:25:14 GMT

Did you check this: http://support.sas.com/kb/59/182.html

Re: LOCKTABLE option in DS2 porogram

BrunoMueller — Tue, 10 Apr 2018 17:46:59 GMT

Have a loo here, looks similar

https://communities.sas.com/t5/SAS-Procedures/Dynamic-hash-column-definition-using-existing-dataset-in-PROC/m-p/258131/highlight/true#M57329

Re: LOCKTABLE option in DS2 porogram

b1958 — Wed, 11 Apr 2018 06:47:30 GMT

Thanks a lot , guys