Implicit pass-through always opens all tables in an SQL query before it prepares the actual query. This is done to get the DBMS column names. When using CONNECTION=UNIQUE option on the LIBNAME statement when accessing a DBMS, a connection occurs for each table that is part of the query, along with a connection for the prepared SQL query that is passed to the DBMS.