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

Conference iosg::all-in-1_v30

Title:*OLD* ALL-IN-1 (tm) Support Conference
Notice:Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:IOSG::PYE
Created:Thu Jan 30 1992
Last Modified:Tue Jan 23 1996
Last Successful Update:Fri Jun 06 1997
Number of topics:4343
Total number of notes:18308

499.0. "building a multiple dataset dataset" by KXOVAX::ISAAC ($cmkrnl_s routin=crashit ; when pick slip arrives) Wed Apr 15 1992 17:51


	Is there any way to map several datasets to a common dataset ?


	I.E.  Something like a relational join.  

	If I had 10 different datasets that all had username and mailname
	fields common is there any way to build an index on them ?

	This should be done relatively quickly so convert large files
	or combining them together isn't realistic.  Doing several binds
	or for(s) on the fly and building a temporary dataset may be one
	possiblility but I fear this may be rather slow.

	Any ideas
	John
T.RTitleUserPersonal
Name		DateLines
499.1/ALIASIRONIC::MINTZMall RatWed Apr 15 1992 20:5631
    John,
    
    How about using /ALIAS?
    
    
    Example: Named Data
    
    .TYPE
    INDEX /YOUR QUALIFIERS
      .
      .
      .
    BIND *PDS to FILE1 with 
     RSE (fielda, fieldb, fieldc - for instance)...
      .
      .
    
    FIELDX
    /ALIAS=FILE2.FIELDX[.FIELDA]
    
    where: FILE2  is some *other* data set - not the one associated with
    		    the BIND
    
    	   FIELDX is the field of interest in this *other* data set 
    		  (and the FMS name of the scrolled field on the INDEX form)	
    
    	   .FIELDA is the name of the field in the phantom data set (*PDS)
    		   that corresponds to the KEY field of FILE2
499.2FOR dataset,dataset WITH RSEFAILTE::LAAHSTwo Cute Celts are better than oneMon Apr 20 1992 12:154
    The FOR function can also search more than one dataset at a time so it
    may be worth a try e.g.
    
    FOR PROFIL,NETWORK WITH .USER = "M" DO WRITE ADD *X ......