topic Re: createing ACCESS db in MVS? in SAS Programming

createing ACCESS db in MVS?

Inp — Mon, 01 Feb 2010 16:43:31 GMT

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

Thanks in advance.

regards
Inp

Re: createing ACCESS db in MVS?

sbb — Mon, 01 Feb 2010 17:12:58 GMT

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

Re: createing ACCESS db in MVS?

LinusH — Tue, 02 Feb 2010 08:22:54 GMT

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

Re: createing ACCESS db in MVS?

JackHamilton — Tue, 02 Feb 2010 18:31:31 GMT

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.

Re: createing ACCESS db in MVS?

sbb — Tue, 02 Feb 2010 18:45:09 GMT

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.

Re: createing ACCESS db in MVS?

JackHamilton — Tue, 02 Feb 2010 18:51:14 GMT

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.