[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

475.0. "EXTERNAL FILE CONCATENATION ??" by CSLALL::PKELTING () Tue Oct 29 1991 12:26

    				Is it possible to concatenate External
    Files ?
    
    FOR EXAMPLE - FILE A.DAT & FILE B.DAT RESIDE IN THE SAME DIRECTORY.
    BOTH FILES ARE STRUCTURED THE SAME, HOWEVER INFORMATION IN A IS WEEK 1
    AND IN B IS WEEK 2. I WOULD LIKE TO CREATE A FOCUS PROCEDURE WHICH
    COULD LOOK AT BOTH A & B AT THE SAME TIME. SIMULAR TO THE USE COMMAND,
    HOWEVER USING EXTERNAL RMS SEQUENTIAL FILES.
    
    Any input is appreciated. 
    
    Thanks
    
    Peter
T.RTitleUserPersonal
Name		DateLines
475.1back to DCLINBAL::OFER_AHere we go again ...Wed Oct 30 1991 02:3215
	Peter ,


		My solution for the very same problem is to issue a DCL command
	from the focus procedure that does an append of the 2 files:

	VMS append file-A file-B /lo

	and that's it ... you only need to report on file-B now ...



		Good luck,
					Ofer.
475.2External Database ConcatenationEVTDD1::CARRIEREJean-Claude CarriereThu Oct 31 1991 03:5522
	As you may have suspected it, FOCUS does not allow you to concatenate
	external databases. The USE command up to FOCUS 6.2 does not apply to
	any of the external databases.

	In fact if the problem of concatenation might seem trivial for
	sequential file, it becomes much more complex as soon as indeces
	are involve. Which file should be search first unless the distribution
	of the data in the index is known ... ?

	This problem has become a serious challenge especially for distributed
	application, were the same table structure exists on different sites
	(potentially under differents databases systems) and you want to
	aggregate the data.

	There has been numerous requests made to IBI lately to provide such
	facility, and hopefully they will.

	In the mean time, for your particular problem, appending the two files
	as mentioned by previously, is surely the simplest solution.

Jean-Claude