Hi All,

Just thinking, will this also capture odbc connections that are made using SQL pass-thru, for instance:

proc sql;
CONNECT TO odbc as cdwaasrc (dsn=CDWxxx user=CDW_xx pw='xxxxx); create table livepolicy as select * from connection to cdwaasrc ( select sourcesystemcode, contractnumber from contract where type in ('P','L') and status='GI' and terminationdate is null and trunc(creationdate)<sysdate-395 and trunc(maintenancedate)<sysdate-395
);
disconnect from cdwaasrc;
quit;

in above instance will it populate anything for CDWxxx ?