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

Conference ilbbak::ibi_focus

Title:	FOCUS, from INFORMATION BUILDERS

Moderator:	ZAYIUS::BROUILLETTE

Created:	Thu Feb 19 1987
Last Modified:	Mon May 05 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	615
Total number of notes:	1779

427.0. "Rdb database JOINS" by HAMSTR::IMFRA () Wed Jun 19 1991 17:22

    
    Does anyone know if FOCUS provides a cross-database JOIN for Rdb 
    databases (even though Rdb itself doesn't provide this cabability)? 
    
    Thanks for any input.
    
    
    Note: question pertains to two Rdb databases, not relations within a
          database.

T.R Title User Personal
Name Date Lines

427.1 Yup...no problem doing this... AIMHI::CIONI_L Thu Jun 20 1991 11:55 13

T.R	Title	User	Personal Name	Date	Lines
427.1	Yup...no problem doing this...	AIMHI::CIONI_L		`Thu Jun 20 1991 11:55`	13
	As long as what you are joining in both databases are of the same format and data consistency. You may have to contact the other remote database site for permission/access to the database for read only purposes. Use AUTORDB.FEX to generate masters for the tables you wish to use in the other database and as long as you have some type of logical pointing to the other database that the .ACX's use, you should be okay. Let me know if you have any questions. I'd be glad to help. LisaC

	As long as what you are joining in both databases are of the same
	format and data consistency.  You may have to contact the other
	remote database site for permission/access to the database for
	read only purposes.

	Use AUTORDB.FEX to generate masters for the tables you wish
	to use in the other database and as long as you have some type
	of logical pointing to the other database that the .ACX's use,
	you should be okay.

	Let me know if you have any questions.  I'd be glad to help.

	LisaC