LOCKTABLE option in DS2 porogram

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

LOCKTABLE option in DS2 porogram

[ Edited ]

Hi 

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;

 

 


Accepted Solutions
Solution
‎04-11-2018 02:47 AM
Valued Guide
Posts: 597

Re: LOCKTABLE option in DS2 porogram


All Replies
Solution
‎04-11-2018 02:47 AM
Valued Guide
Posts: 597

Re: LOCKTABLE option in DS2 porogram

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

Thanks,
Suryakiran
SAS Super FREQ
Posts: 825

Re: LOCKTABLE option in DS2 porogram

Occasional Contributor
Posts: 17

Re: LOCKTABLE option in DS2 porogram

Thanks a lot , guys

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 120 views
  • 0 likes
  • 3 in conversation