News

Although the SQL Procedure Pass-Through Facility has always passed joins to the DBMS, it is now possible to pass joins to the DBMS without using Pass-Through. Beginning in Version 7, the LIBNAME ...
libname myoralib oracle user=testuser password=testpass path='myoraserver' dbconinit="EXEC MY_PROCEDURE"; proc sql; update myoralib.mytable set acctnum=123 where acctnum=567; quit; When the libref is ...