Desktop productivity for business analysts and programmers

Connecting to db2, ssid option invalid

Posts: 1

Connecting to db2, ssid option invalid

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?

Trusted Advisor
Posts: 3,215

Re: Connecting to db2, ssid option invalid

Posted in reply to SergeiKlinsmann

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.  

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation