When reusing a metadata-defined library connection in SQL procedure pass-through code, the following error might occur:
proc sql;
connect using oralib;
ERROR: A Connection to the META DBMS is not currently supported, or is not installed at your site.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
create table test as
select * from connection to oralib
(select * from table1);
NOTE: Statement not executed due to NOEXEC option.
quit;
The META engine does not support using the "connect using libref" syntax. This syntax can be used only when a LIBNAME statement is defined with the SAS/ACCESS® engine.
To determine whether your library is using the META engine or the SAS/ACCESS engine, run this code:
The log shows what engine is being used: