Solved: LOCKTABLE option in DS2 porogram

b1958 · Posted 04-10-2018 08:04 AM

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;