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

Conference orarep::nomahs::dbintegrator_public_public

Title:	DB Integrator Public Conference
Notice:	Database Integration - today! Kit/Doc info see note 36
Moderator:	BROKE::ABUGOV

Created:	Mon Sep 21 1992
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1171
Total number of notes:	5187

1055.0. "Forte', Mumps, DBI, gateway, which way to go?" by ORAREP::MPOS02::PEREZ (Trust, but ALWAYS verify!) Fri May 03 1996 15:29

    I received a question from our Forte' person, who wants to know about
    using DB Integrator and/or the Mumps gateway in an object environment,
    Forte' in particular.
    
    The customer will have a Mumps database and an Oracle database.  Folks
    here are trying to decide whether to put DBI in the middle or just
    stick in a Mumps gateway (presuming Forte' can talk directly to Oracle).  
    
    If we were to use DBI with Forte' (or even C++), are there pre-defined
    APIs available for DBI and/or the gateways that can be used by Forte'?
    
    I presume in C++ they would just use standard SQL, but are there any
    services available for Forte'?

T.R	Title	User	Personal Name	Date	Lines
1055.1	works with DBI	BROKE::ABUGOV		`Fri May 03 1996 15:57`	8
	Fort� currently has an interface which works with Rdb, and it has been tested against DBI also. You could plug Fort� into DBI and access/integrate Oracle and DSM data. Hope this helps, Dan
1055.2	HP VSAM from Forte'? From RMS Gateway?	ORAREP::MPOS02::PEREZ	Trust, but ALWAYS verify!	`Wed May 08 1996 15:13`	13
	Well, it appears that I'm just chock FULL of Forte' questions this week... I got another request, this time from some Forte' people. They are trying to access VSAM data from an HP system, and are encountering difficulties. I have the document titled "DEC DBIntegrator Gateway for RMS - Accessing RMS and VSAM Files with SQL" dated December 1993. According to this, it should be possible to read VSAM files, although I don't see any SPECIFIC mention of HP VSAM. Has anyone had any experience using this gateway to get HP VSAM data, and if so, what kind of "challenges" did you encounter?
1055.3	Sorry	BROKE::SERRA	You got it, we JOIN it....DBI	`Thu May 09 1996 10:41`	11
	We do not support VSAM on HP. The only VSAM supported is IBM based, we use the DTF product to accomplish this. It only runs on IBM. Sorry Steve
1055.4	To reinforce what Steve said...	BROKE::WRIGHT	NYO&W-Trains Spoken Here-SUSIEQ	`Thu May 09 1996 13:17`	11
	The preface of "Accessing RMS and VSAM Files with SQL" states, "...You can also use DEC DB Integrator Gateway for RMS with SQL for read-only access to data sets on IBM MVS systems accessible through the DECnet/SNA Data Transfer Facility (DTF)." The key to making all this work is DTF which makes VSAM on IBM MVS systems look like RMS to applications such as the RMS Gateway. Therefore, unless DTF is available for HP VSAM (I don't think so.), the RMS Gateway will not work with it. It is possible that a Custom Driver solution might be constructed. Tom
1055.5		ORAREP::MPOS01::PEREZ	Trust, but ALWAYS verify!	`Thu May 16 1996 12:49`	3
	Thanks, that's what I needed to know. Somewhere along the line (I think from talking to someone in support) I got the impression that DBI would work with HP VSAM files. But, if it don't it don't!