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?

Valued Guide
Posts: 3,208

Re: Connecting to db2, ssid option invalid

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