[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

995.0. "Rdb/VMS ->IBM ADABAS,SQL/DS, UNISYS MAPPER" by TAIJI::JULIACHEONG () Tue Sep 24 1991 21:55

	Currently, we are working on a very large steel plant MIS project.
	The customer is looking for interoperability from Rdb/VMS or VMS
	to the following existing databases:

	IBM 4381	- ADABAS/Natural
	IBM 4341	- SQL/DS
	Unisys 2200	- MAPPER
			  UDS

	I have search through this notesfile, but I cannot find any note
	mentioning existing access tools (DEC or 3rd party).  I have these 
        questions:

	1.  Is there any access tools available for each database ?

        2.  If customer is willing to write task-to-task programs for access,
            what communication products are required ?

        3.  Do we have any tested sites for these databases access ?

        Regards and Thanks.
        Julia (PRC EIS).
T.RTitleUserPersonal
Name
DateLines
995.1"It don't come easy" -George HarrisonMBALDY::LANGSTONThe secret is strong ears.Tue Sep 24 1991 22:3035
Re:
�        2.  If customer is willing to write task-to-task programs for access,
�            what communication products are required ?

From SPD 26.88.06, for 
DECnet/SNA VMS APPC/LU6.2 Programming Interface V2.2:

      The DECnet/SNA VMS Advanced Program-to-Program Communica-
      tions/LU6.2 Programming Interface (APPC) is a layered software
      product that allows user-written applications running on suit-
      ably configured VMS systems either within a DECnet network or
      running VMS/SNA software to exchange messages with cooperating
      applications in an IBM[R] host. The APPC software exists in the
      VMS system as a shareable image. Access between the cooperating
      Digital and IBM applications is via the DECnet/SNA Gateway or
      VMS/SNA software.

      The APPC product is a set of subroutines which are called by
      VMS programs which act as Logical Unit 6.2 (LU6.2) transaction
      application programs. These subroutines allow a VMS transaction
      application to:
   
      o  Activate and deactivate sessions
      o  Allocate and deallocate LU6.2 basic and mapped conversations
      o  Send and receive data
      o  Request confirmation and confirm transactions
      o  Send and receive error information
      o  Define and delete local LU names and TP names
      o  Supply program initialization parameters
      o  Supply session-level security and inbound conversation level

�        3.  Do we have any tested sites for these databases access ?
We have used APPC/LU6.2 to access AS/400 and S/38.

Bruce
995.2Natural/Rdb ?NOT003::DENTIIan Dent @NOT, Nottingham, UKWed Sep 25 1991 15:2212
    To allow access to both Rdb/VMS data and IBM Adabas data or to provide
    a transfer method from Adabas on the IBM to Rdb/VMS you could consider
    using Natural.
    
    This will run on the Vax and communicate with the IBM via a product
    called Net-work from Software AG. This uses LU6.2 as a communication
    protocol.
    
    A Natural program on the Vax can read from an IBM Adabas file and
    write the data to a Rdb/VMS table (or vice versa).
    
    Ian
995.3What operating system is used on the two IBM systems?BROKE::THOMASAnne Thomas DTN 264-6094Mon Oct 07 1991 23:3513
Whenever asking about interoperability to IBM systems it's very important
that you identify the IBM environment that you're working with.  For 
example, Adabas runs on MVS, VM, and DOS/VSE systems.  SQL/DS runs on 
VM and DOS/VSE systems.  The applications can run under CICS, TSO, 
IMS-DC, CMS, or a number of other environments.  I can't tell you what
solutions are available until I know more about the IBM environments.

Also, what level of interoperability is required?  Do they need to be 
able to directly access (read and write) data in place on the IBM systems
or can they look at snapshot data which is downloaded to the VAX?

If the customer uses VM (as opposed to DOS/VSE) then you might be able 
to use DTF to handle all of your data transfer requirements.
995.4Further info. on Existing DBTAIJI::JULIACHEONGTue Oct 15 1991 12:1319
    Sorry for the late response.  I am working on the proposal for the
    Steel and Iron opportunity in Shanghai during the past two weeks. 
    Access to Easynet is quite difficult from there.  
    
    Thank you for the replies.  As for .-1, the customer's existing
    machines are running:
    
    IBM 4381     + MVS        + ADABAS/Natural
    IBM 4341     + DOS/VSE    + SQL/DS
    Unisys 2200  + OS 1100    + MAPPER
    
    The interoperability features that they are looking for from Rdb/VMS to
    these databases are bi-direction (interactive) read/write access.
    
    I will try to provide any additional information that you think
    appropriate.
    
    Regards.    
    Julia.
995.5Yes you can, may be!SIERAS::NAKAPPANTue Oct 15 1991 20:5519
    With regard to interoperability between Rdb/VMS and SQL/DS, I
    would suggest that you contact NOMAD/VISTA, a third-party database/4GL
    environment that according to the marketing literature claims
    transparent access from a desktop (MS/DOS) to both systems.
    
    With regard to Unisys/Mapper, there is no known interoperability
    product.  Mapper has been ported to Unix System V environments, but
    not to Risc/Ultrix.  If the investment in Mapper is not significant,
    I would propose a migration effort.  You may also want to post your
    note in FASDER::UNISYS_CONVERSION.
    
    However, there are terminal emulator products available for UNISCOPE
    protocol emulation on the VTxxx terminals to connect into the Unisys
    2200 environment.  Please see Note 21.4 of the above-referenced
    Notesfile.
    
    Hope this helps
    
    Murli