[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

921.0. "Binding two data sets for indexing" by WELCLU::LI (Sau Ha Li, Welwyn) Wed Jun 24 1992 11:29

    Hello all,
    
    I have a customer who has 2 data sets with the following fields:
    
    dataset 1 : Sales Id (key), Username, Full name
    dataset 2 : report type (key), description, location
    
    He has a list of VMS files (reports) with filename format: 
     
    <report type><sales id>.REP   (e.g. AB123.rep)
    
    What he wants to do is to create an index of all the reports found, 
    displaying the Sales person Name and report Description.
    
    Is it easier to build a temp dataset with sales persons name and 
    description and use that in indexing or is there a way to use BIND to 
    create the index ?
    
    
    thanks in advance,
    Sau Ha

T.R Title User Personal
Name Date Lines

921.1 Not sure if this answers the question... SHALOT::NICODEM Who told you I'm paranoid??? Wed Jun 24 1992 13:54 25

T.R	Title	User	Personal Name	Date	Lines
921.1	Not sure if this answers the question...	SHALOT::NICODEM	Who told you I'm paranoid???	`Wed Jun 24 1992 13:54`	25
	I'm kind of guessing on this one, since I'm not exactly sure I understand what you want to do. But it seems that the actual data set you want to bind to is the directory of files (reports) that are out there. I think your two ALL-IN-1 data files are only a "lookup" mechanism to get the user's name and the report type, given their "codes". If that assumption is correct, you might be able to do something like: BIND FILES TO OA$DIR:"REPORT$DIR:." and then use the /ALIAS qualifer, along with ALL-IN-1 data set references, in the various fields of the index form. If you wanted to just look at the reports for the person with Sales ID = "123", for example, you might even change the BIND to something like: BIND FILES TO OA$DIR:"REPORT$DIR:." WITH .NAME <=> "123" If your two key fields (Sales ID and Report ID) are already stored in symbols, you should be able to refer to their full descriptions (in the ALL-IN-1 data files) using DSRs such as SALES_ID.USERNAME[#SID] or REPORT_TYPE.DESCRIPTION[#REPORT_ID]. Is that what you're getting at? F

	I'm kind of guessing on this one, since I'm not exactly sure I understand
what you want to do.  But it seems that the actual data set you want to bind
to is the directory of files (reports) that are out there.  I think your two
ALL-IN-1 data files are only a "lookup" mechanism to get the user's name and
the report type, given their "codes".

	If that assumption is correct, you might be able to do something like:

	BIND *FILES TO OA$DIR:"REPORT$DIR:*.*"

and then use the /ALIAS qualifer, along with ALL-IN-1 data set references, in
the various fields of the index form.  If you wanted to just look at the reports
for the person with Sales ID = "123", for example, you might even change the
BIND to something like:

	BIND *FILES TO OA$DIR:"REPORT$DIR:*.*" WITH .NAME <=> "123"

	If your two key fields (Sales ID and Report ID) are already stored in
symbols, you should be able to refer to their full descriptions (in the ALL-IN-1
data files) using DSRs such as SALES_ID.USERNAME[#SID] or
REPORT_TYPE.DESCRIPTION[#REPORT_ID].

	Is that what you're getting at?

	F