04-10-2018 08:04 AM - edited 04-10-2018 08:41 AM
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;
Need further help from the community? Please ask a new question.