topic Re: How to connect to IMS database using SAS on mainframe in SAS Procedures

How to connect to IMS database using SAS on mainframe

Petersas — Mon, 16 May 2016 10:52:14 GMT

Hi,

Can anyone let me know how to connect to IMS database and pull data from segment using SAS on mainframe.

Any help will be apprecitated.

Thanks,

Peter.

Re: How to connect to IMS database using SAS on mainframe

jklaverstijn — Mon, 16 May 2016 13:39:33 GMT

Hi Peter,

SAS still features the SAS/Access to IMS product. This would be the proper way to go. See the online doc.

Hope this helps,

- Jan.

Re: How to connect to IMS database using SAS on mainframe

Petersas — Tue, 17 May 2016 06:36:35 GMT

Hi Jan,
I have check the link you have provided. can you share a sample program if you have for the same.
Thanks,
Peter

Re: How to connect to IMS database using SAS on mainframe

jklaverstijn — Tue, 17 May 2016 11:57:42 GMT

Hi Peter,

The online doc has many examples. It would be difficult for me to add my own as my current organization has stopped IMS over a year ago. And for me personally IMS is an echo from the past. I wrote my last line of COBOL / IMS code in 1987.

If you look up the SAS/Access Interface to IMS: Reference on support.sas.com you will find sample code.

Do keep in mind that the interface is a licensed product. You may need to contact your SAS representative to find out if this is all feasible. Unless your organization has licensed and installed the product none of the code would work.

Hope this helps,

- Jan.