DATA Step, Macro, Functions and more

createing ACCESS db in MVS?

Reply
Frequent Contributor
Frequent Contributor
Posts: 81

createing ACCESS db in MVS?

Hi
Is it possible to use proc export to create MS access db in MVS operating system?

Thanks in advance.


regards
Inp
Super Contributor
Super Contributor
Posts: 3,174

Re: createing ACCESS db in MVS?

Does your site have a SAS z/OS (MVS, IBM mainframe) software that includes SAS/Access? I would expect the answer to be no, not to export directly from MVS to an Access "mdb".

Scott Barry
SBBWorks, Inc.

SAS/Access Interface to PC Files: Reference
Microsoft Access Database Files
Microsoft Access File Essentials
http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a003103770.htm
Super User
Posts: 5,260

Re: createing ACCESS db in MVS?

I agree with Scott. SAS/ACCESS to PC Files Formats is not listed under available software for ZOS.
There are two ways I can see to export almost directly from ZOS.
-If you have a SAS/CONNECT connection to a Windows, Linus or UNIX host.
-If you have Enterprise Guide connected to your ZOS SAS server.

/Linus
Data never sleeps
Frequent Contributor
Posts: 102

Re: createing ACCESS db in MVS?

If you use SAS/Connect to Linux or Unix, you will still need a Windows server. As far as I can tell, the PC Files Server runs only on Windows. Unix and Linux access works by connecting to a PC server (I am assuming that SAS is using "PC" as a synonym for "Windows").

Given that, I'm not sure why access is not supported from z/OS. Perhaps they just didn't want to deal with the EBCDIC<->ASCII issues.
Super Contributor
Super Contributor
Posts: 3,174

Re: createing ACCESS db in MVS?

I expect there is some aspect that is "proprietary" and would not execute on z/OS. So, unless there is a "compatible" format, as in unloaded database, I don't see the Access-function code working on the IBM mainframe platform.

Scott Barry
SBBWorks, Inc.
Frequent Contributor
Posts: 102

Re: createing ACCESS db in MVS?

The Access code doesn't run on Linux or Unix either - the actual conversion is done with a client server model, with Linux/Unix as the client and Windows as the server doing the work. So I don't see why it wouldn't be possible to have the server work with z/OS as well - the data file is just bits, which z/OS has no problem handling.
Ask a Question
Discussion stats
  • 5 replies
  • 191 views
  • 0 likes
  • 4 in conversation