topic Re: Connecting DB2 Database using sas base. in SAS Programming

Connecting DB2 Database using sas base.

mlogan — Tue, 13 Sep 2022 03:11:22 GMT

Hi All,

I am having issue connecting to DB2 database server using sas base. Can someone assist me on how to accomplish that. I have tried following many online blog, but everything failed.

Thanks for your help

Shak

Re: Connecting DB2 Database using sas base.

SASKiwi — Tue, 13 Sep 2022 03:31:24 GMT

First of all you can't access DB2 using Base SAS, you need the SAS product SAS/ACCESS to DB2 both installed and licensed. Has this been done? If so has anyone successfully used it yet?

Re: Connecting DB2 Database using sas base.

andreas_lds — Tue, 13 Sep 2022 05:37:56 GMT

Please post the code you used to connect to the db and the log of that step.

Re: Connecting DB2 Database using sas base.

ErikLund_Jensen — Tue, 13 Sep 2022 07:50:47 GMT

Hi @mlogan

Another possibility is to install an ODBC driver that acts as a bridge to DB2, so SAS can access DB2 batabases using access to ODBC and an entry in the odbc.ini file pointing to the DB2/ODBC driver. It works very well for us, both in out current Linux installation and earlier on Windows servers.

Unfortunately I can't be to further help when it comes to the technical details about installation and setup. We used external help for that part.

Re: Connecting DB2 Database using sas base.

Ksharp — Tue, 13 Sep 2022 11:58:56 GMT

Firstly, using " proc setinit;run; " to check if you have ACCESS/ODBC license,

if you have ODBC driver of DB2 , you could follow this ,

after config a data source succesfully ,

using " libname x odbc dsn= " to connect to DB2.