[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

540.0. "RMS with TABLETALK - Novice Questions" by NSDC::RADFORD () Mon Jan 11 1993 13:14

                <<< GVPROD::BEORN:[NOTES$LIBRARY]FOCUS.NOTE;1 >>>
                      -< European FOCUS Notes Conference >-
================================================================================
Note 267.0            RMS with TABLETALK - Novice Questions           No replies
NSDC::RADFORD                                        27 lines  11-JAN-1993 19:09
--------------------------------------------------------------------------------
    I am currently investigating the best way to structure an RMS reporting
    file extract in order to use FOCUS and in particular TABLETALK to carry
    out queries on the data.  However I know absolutely nothing about FOCUS
    other than what I have been able to learn from this notesfile, so would
    be grateful if anyone could help me by answering a few questions:
    
    - It looks like I will have one (currently sequential) RMS file containing 
    much of the data on which reporting is to be carried out, in a variable 
    record format, with a different record type for each different type of
    data ("person", "account", "branch", etc).  Information containing code
    descriptions will be available in separate files.  If necessary, I will
    have to write procedures to reformat the data into different files or a
    different record structure, but would prefer not to have to.
    
    - Can the data from different files be joined using FOCUS such that when
    using TABLETALK, the users are not aware that the data is coming from
    different files, and if so, then briefly, how?
    
    - Can a join be made between different records, eg for a person, person
    plus account details, this information being found in several different
    record types within the same file; or should this information be split 
    out from the file that I receive into separate files, or stored in a 
    single record per person? 
    
    Many thanks for any help,
    
     Karen.

T.R	Title	User	Personal Name	Date	Lines
540.1	See shire::focus 267.1	TAVIS::LANDAU	Tzvi Landau - DEC Israel/DS/IS	`Wed Jan 13 1993 01:58`	1