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

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

THALLA_REDDY — Mon, 23 Nov 2020 09:36:01 GMT

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 ?

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

Sajid01 — Thu, 18 Mar 2021 20:20:23 GMT

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.