66646 - An access violation occurs after you try to query the DICTIONARY.Tables table with a DS2 SET statement

Problem Note 66646: An access violation occurs after you try to query the DICTIONARY.Tables table with a DS2 SET statement

The following code works in SAS 9.4M6, but it produces errors when run in SAS Viya 3.5.

proc copy in=sashelp out=work;
select cars;
run;

proc ds2;
data null;
method init();
sqlexec('drop table work.trash1 force');
sqlexec('drop table work.trash2 force');
sqlexec('create table work.trash1 as
select * from work.cars

{options locktable=share} limit 1');
   sqlexec('create table work.trash2 as
   select * from work.cars{options locktable=share}
   limit 2');
end;
enddata;
run;
quit;

title "PROC FEDSQL RESULT SET";
proc fedsql;
   select table_name
   from dictionary.tables
   where table_cat='WORK'
   and table_name like 'T%';
quit;

title "PROC DS2 RESULT SET";
proc ds2;
data;
method run();
set

{select table_name from dictionary.tables where table_cat='WORK' and table_name like 'T%'}
;
end;
enddata;
run;
quit;

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	Linux for x64	Viya	Viya

Type:	Problem Note
Priority:	medium
Topic:	SAS Reference ==> Procedures ==> DS2

Date Modified:	2020-10-28 09:03:23
Date Created:	2020-09-15 08:36:26

Support

Problem Note 66646: An access violation occurs after you try to query the DICTIONARY.Tables table with a DS2 SET statement

Operating System and Release Information