topic Connecting to db2, ssid option invalid in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-db2-ssid-option-invalid/m-p/146190#M11567 <HTML><HEAD></HEAD><BODY><P>I'm trying to use proc sql to connect to a db2 database. For some reason SAS tells me that in the statement <STRONG>connect to db2 (ssid=somessid); </STRONG>the ssid= option is illegal. I also tried to give SAS the option <STRONG>options DB2SSID=somessid; </STRONG>but I also get an error about the DB2SSID option being unrecognized. The code works fine in normal SAS. How do I fix this?</P></BODY></HTML> Tue, 16 Sep 2014 09:49:44 GMT SergeiKlinsmann 2014-09-16T09:49:44Z Connecting to db2, ssid option invalid https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-db2-ssid-option-invalid/m-p/146190#M11567 <HTML><HEAD></HEAD><BODY><P>I'm trying to use proc sql to connect to a db2 database. For some reason SAS tells me that in the statement <STRONG>connect to db2 (ssid=somessid); </STRONG>the ssid= option is illegal. I also tried to give SAS the option <STRONG>options DB2SSID=somessid; </STRONG>but I also get an error about the DB2SSID option being unrecognized. The code works fine in normal SAS. How do I fix this?</P></BODY></HTML> Tue, 16 Sep 2014 09:49:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-db2-ssid-option-invalid/m-p/146190#M11567 SergeiKlinsmann 2014-09-16T09:49:44Z Re: Connecting to db2, ssid option invalid https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-db2-ssid-option-invalid/m-p/146191#M11568 <HTML><HEAD></HEAD><BODY><P>When you are using the explicit pass through method, you are required to code all options you already did with a libname.</P><P>A new separate connection is build and nothing is shared from previous ones (unless you are using dedicated options).<BR />Both approaches are part of normal SAS. Documented with SAS/ACCESS.&nbsp; What are you using?</P><P></P><P>With Easy common standard SQL there is no need to code a "connect to", all is translated by SAS as an implicit pass through processing.&nbsp;&nbsp; </P></BODY></HTML> Tue, 16 Sep 2014 10:41:54 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connecting-to-db2-ssid-option-invalid/m-p/146191#M11568 jakarman 2014-09-16T10:41:54Z