Date: Fri, 7 Jun 1996 17:58:41 GMT
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: "John Z. Zhao" <jzz@LONGHORNS.QUANTUM.EPSILON.COM>
Organization: Epsilon Data Management
Subject: Re: Using SAS with DB2-Tables
SAS is not a RDBMS system. It's understandable for the company to chose
DB2 over SAS, even thought SAS Inc. has been trying very hard to have its
share on data wareshouing. But from DBMS's view point, RDBMSs such as
DB2, SYBASE are much easier to build a data warehousing, specially when
it is VLDB (very larage database). SAS still has long way to go in this area.
SAS does have some advantages on data wareshouing applications. It has a full
range of analytic and desk-top tools for statistical analysis, data mining and
reporting writing. SAS/ACCESS together with SAS/CONNECT would enable SAS
application developers, both using MVS and PC, to port some of your application
or develop application READING data from DB2 tables. It would be very
difficult to put SAS output back to DB2 tables.
I have been trying to use SAS to update DB2 tables in VLDB. Performance is
not encouraging at all.
Thomas Kregeloh (100577.1775@CompuServe.COM) wrote:
> I am building a large data warehouse for an insurance company. The
> DWH will be held on an MVS-Host.
> It is intended to use DB2 instead of SAS-Tables for all of the
> Any comments / experiences etc. are very welcome.
> Thomas Kregeloh, Hamburg
Epsilon Data Management
Tel: 617-273-0250 x6219