LOCKTABLE option in DS2 porogram

[b1958]

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;

[SuryaKiran · Accepted solution]

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

[BrunoMueller]

Have a loo here, looks similar

https://communities.sas.com/t5/SAS-Procedures/Dynamic-hash-column-definition-using-existing-dataset-...

[b1958]

Thanks a lot , guys