[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

756.0. "Sybase interface to Rdb?" by BRULE::CUTRI (Keith Cutri - DTN: 252-7092) Tue Oct 02 1990 22:41

    Does Sybase interface to the Rdb engine?  In other words, is Sybase an
    SQL compliant system?
    
    I have a customer who is considering the VAX/Rdb but has some existing
    Sybase users.  Any ideas?
    
    -Keith 
T.RTitleUserPersonal
Name
DateLines
756.1No Sybase support for RdbTRCA03::MCMULLENKen McMullenWed Oct 03 1990 17:4614
    Keith,
    
    Sybase does not interface with Rdb/VMS. Just because a system is an
    "SQL compliant system" does not mean that one vendor's tools will talk
    to another vendor's relational database. 
    
    Sybase makes noise about their "Open Data Architecture", which means
    that you could hook 3gl programs to their toolset that could read and
    write to other data resource managers. But then you can do this with
    just about everone's products. The problem with this approach is that
    there is no way to co-ordinate updates (ie 2PC, data integrity) with
    the SYSBASE tools and other data resource managers.
    
    Ken
756.2Sybase SupportSAC::STEPHEN_IIain StephenThu Oct 04 1990 11:1623
Take an application view...

When you say "a customer who is considering the VAX/Rdb but has some existing
    	      Sybase users"

Do you know if the applications they use where written with Fastbuild or
APT workbench. 

If the Answer is Fastbuild, then something may be possible.  Fastbuild is
Sybases version of UnifAce with restricted database drivers.   UnifAce can
supply additional database drivers for the product, so you could get an 
Rdb/VMS database driver from them.  Once you have the Rdb/VMS driver, and 
creat an Rdb database, Uniface/Fastbuild can be used to move the database 
from one database system to the other.  Changing a definition in the 
Fastbuild conceptual schema tells the application to get data from the Rdb
database not the Sybase one.

In theory its a great idea...

On the other hand, if they used APT Workbench, you may be stuck with Sybase 
unless you start from scratch.

Iain.
756.3Try Sybase's OPEN Server ProductPOBOX::LACEYACMS/Rdb, the transaction AutobahnMon Oct 08 1990 16:0712
    Sybase has announced their 'OPEN Client' & 'OPEN Server' products.
    I believe you can use the OPEN Server API to write routines that utilize
    Rdb. In that way a Sybase application can access both Rdb & Sybase as
    if they were both Sybase databases. Sybase is already touting this
    functionality for access to DB2 read/write-able. 
    
    Sounds like a neat marketing idea!!, but you have to remember the 'OPEN
    Server' is not so open it uses a proprietatry API just as ACMS would
    without the application knowing whether it was utilizing Rdb, Sybase,
    RMS, ...
    
    _Paul