A FEDSQL procedure query that reads from the DICTIONARY.Tables table runs without issue within the DS2 procedure on SAS^® 9.4M6 (TS1M6). However, the same code produces the following error messages if it is run on a SAS^® Viya^® 3.5 Compute Server:

See the Full Code tab for an example of code that can cause this problem.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Operating System and Release Information

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;

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at

A fix for this issue for SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M5 is available at: