topic SAS-DB2 connectivity(mainframe) in SAS Procedures

SAS-DB2 connectivity(mainframe)

Petersas — Thu, 31 Dec 2015 15:29:42 GMT

Hi,

I have a DB2 query in mainframe which is pulling data from tables. I'm currently trying to run the same DB2 query in SAS program and want to fetch the data from the tables. I'm new to SAS-DB2. Please provide me pointers on how to achieve this.

I tried the following:

PROC SQL;
CONNECT TO DB2 (SSID=DBQ2);
%PUT &SQLXMSG;
CREATE TABLE SASDS AS
SELECT * FROM CONNECTION TO DB2
(
SQL QUERY
);
%PUT &SQLXMSG;
DISCONNECT FROM DB2;
%PUT &SQLXMSG;

but was getting error.

ERROR: Unable to load the DB2 Call Attach Facility.
ERROR: A Connection to the DB2 DBMS is not currently supported, or IS not installed at your site.

PROC SQL set option NOEXEC
NOTE: Statement not executed due to NOEXEC option.

Please advise.

Thanks in Advance!!!

Re: SAS-DB2 connectivity(mainframe)

LinusH — Thu, 31 Dec 2015 15:53:59 GMT

Seems that something is lacking in the configuration.

Where is your SAS program executing?

What kind of DB2 client are your using (native, ODBC)?

Do you have the necessary license?

Does anybody at your site managed to connect from SAS to this DB2 earlier?

Versions (SAS, DB2)...?

http://support.sas.com/techsup/notes/v8/1/010.html

Re: SAS-DB2 connectivity(mainframe)

Petersas — Fri, 01 Jan 2016 03:29:56 GMT

Hi LinusH,

Where is your SAS program executing? -- SAS is working on Mainframe.

What kind of DB2 client are your using (native, ODBC)? -- SAS SQL PROC

Do you have the necessary license? --

---Base Product
---SAS/ACCESS Interface to DB2
---SAS/ACCESS Interface to IMS-DL/I

Does anybody at your site managed to connect from SAS to this DB2 earlier?

Versions (SAS, DB2)...? -- SAS 9.1.3

Thanks.