09-16-2014 05:49 AM
I'm trying to use proc sql to connect to a db2 database. For some reason SAS tells me that in the statement connect to db2 (ssid=somessid); the ssid= option is illegal. I also tried to give SAS the option options DB2SSID=somessid; but I also get an error about the DB2SSID option being unrecognized. The code works fine in normal SAS. How do I fix this?
09-16-2014 06:41 AM
When you are using the explicit pass through method, you are required to code all options you already did with a libname.
A new separate connection is build and nothing is shared from previous ones (unless you are using dedicated options).
Both approaches are part of normal SAS. Documented with SAS/ACCESS. What are you using?
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.