[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

570.0. "MUMPS -> RDB" by TRCO01::SANDHU () Fri Feb 16 1990 15:08

    Is there any MUMPS <-> RDB interface? I have been asked this by
    a customer, but my problem is: 
    
    1. I have no understanding of MUMPS.
    2. I don't really know how to answer this question or re-position
       it. The customer has a lot of applications written under MUMPS,
       and as they are looking for a distributed database would like
       minimize the conversion process as much as possible.

    The competitor here is Sybase, incidentally. Believe it or not,
    Oracle was not even considered - rumors about lack of support/delivery
    promises etc. are catching up with Oracle.
    
    Thanks for any help.
T.RTitleUserPersonal
Name
DateLines
570.1Module Language!COOKIE::BERENSONWords are a deadly weaponFri Feb 16 1990 19:272
I believe DSM can call anything that matches the VAX Calling Standard.
Therefore, you can use SQL Module Language and access it from DSM!
570.2exitTRCA03::SANDHUFri Feb 16 1990 21:006
    re: -1 
    Can you explain a bit more please? Its good to get some sort of
    a YES, but I'd like to be able to explain this to the customer.
    And considering I know nothing about this subject, will truly
    appreciate a bit more detail. Thanks
    
570.3Give us a call, we'll tell you how.DSM::CRAIGNice computers don&#039;t go down :-)Mon Feb 19 1990 04:5925
    VAX DSM fully supports the VMS Procedure Calling and Condition Handling
    Standard.  For your customer to access a VMS language, database product
    System Service or Run-Time Library routine, they would need to write a
    call from DSM to the product, and link it into the DSM image as a ZCALL
    function.  (The ANSI Standard allows implementors to add new functions,
    as long as they are preceeded by a "Z").  So, to fetch an RDB record
    your customer could write a ZCALL which would look like this:
    
    SET X=$ZC(%RDB,RECORD,"FETCH")
    
    which (in this hypothetical example) would execute a FETCH operation on
    record RECORD through a call to RDB.
    
    There are examples of how to do this in the DSM Programmers Reference
    manual.  You can also get more detailed help in the DSM::VAXDSM notes
    file.
    
    The DSM Product Group would be very interested in hearing more about
    your customers requirements.
    
    						Bob Craig
    
    Senior Software Support Specialist
    DSM Product Group, MRO2-3/E5
    Phone: DTN: 297-6490 or (508) 467-6490
570.4SQL Module LanguageLACKEY::HIGGSIn Hans&#039; and Kevin&#039;s excellent adventureMon Feb 19 1990 18:474
AS Hal says, you should be able to call SQL Module Language from DSM.
However, note that SQL Module Language does not currently support the passing
of records -- only individual items.  I presume that you can pass individual
items (of type integer, or character string, etc.) from DSM?
570.5DSM::CRAIGNice computers don&#039;t go down :-)Mon Feb 19 1990 21:2510
    Yes.  In fact, DSM doesn't have the concept of a record, and would,
    therefore, pass one string at a time.
    
    For those who want more information about MUMPS, in general, and VAX
    DSM, in particular, I've recently written a "white paper" which is
    available at DSM::SYS$PUBLIC:DSM_INFO.* (.TXT, .LN03, .PS).
    
    						Bob Craig
    
    DSM Product Group