[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

934.0. "SQL differences between Rdb, Oracle, Non-Stop SQL?" by YOSMTE::OLDING_NI (dtn 549 5928) Thu May 30 1991 19:42

    I am trying to get a list of differences in SQL implementations for
    Rdb/VMS, ORACLE and Non-Stop SQL from Tandem ie What super-sets have
    been implemented, and how they differ. I have a customer who may move
    from Tandem, but would like info on how close the SQLs match.
    	Can anyone point me at a lead for tracking this down ?
    
    Nigel
T.RTitleUserPersonal
Name
DateLines
934.1Here's a pointerIJSAPL::OLTHOFHenny Olthof @UTO 838-2021Fri May 31 1991 17:1315
    A research on this subject has been done by a database consultant in
    the Netherlands (assigned by two large companies Shell and Philips).
    Result is a handbook on portability between DB2, Informix, Oracle, OS/2
    database manager, SQL/DS and Rdb/VMS.
    
    Author is Rick van der Lans (dutch participant in ANSI SQL committee).
    More information and orders through the adrress below. Heared that
    Codd&Date Consultants are interested in making this available in the
    US).
    
    R/20 Consultancy
    Postduif 1
    2171 PJ Sassenheim
    Netherlands
    tel (02522 - 18487)  [Need access to Holland first]
934.2TROA09::NAISHO�4ME Paul Naish DTN 631-7280Tue Jun 04 1991 16:1510
    I was looking for the differences between just Rdb and ORACLE. Check
    out the replies in the SQL NOTES Conference (NOVA::SQL) note 1333.
    
    Bottom line was ORACLE has a lot of non-standard extensions which are
    very useful but prohibit easily porting applications between DB's.
    
    You problem is not how the SQL's compare but what Tandem specific
    extensions the customer has used. Given the market, they may have tried
    to keep a degree of compatibility with DB2 as we have in Rdb which
    might be a common comparing point.