Can make the Pass through SQL option as default in a query Builder of SAS Enterprise Guide 8.3 ?

[THALLA_REDDY]

Hi Team,

We have installed SAS Enterprise Guide 8.3 newly in our environment. We will connect to a DB2 database to query some data and in that process we need the PassThrough SQL option to be enabled by default instead of selecting it every time, Is there a way to do it from User or Admin side ?

[Sajid01]

Hello @THALLA_REDDY 

SAS Admin can add DB2 databases to metadata and it can then be used like any other library.
As of SAS 9.4M6 I don't think we can make SQL pass through the default .
Suggest approaching SAS Tech Support.