R: logical view over mult files

[Finucci Domenico <Domenico.Finucci@xxxxxxxxxxxx>]

Build a key file (that's a file that contains all the keys you need, in the
correct order). This will allow you to get remaining information by linking
to original data files. 
How  much data will your DB contain ? 

Sincerely
Domenico Finucci
Fiditalia , Milano, 02- 4301-2494


-----Messaggio originale-----
Da: Sam Kanakanui [mailto:skanakanui@triad.rr.com]
Inviato: martedì 12 dicembre 2000 13.28
A: midrange-l@midrange.com
Oggetto: logical view over mult files


Hello,

I am trying to extract data from a BOM system with preferably a single view
of the data.  The data is stored in 4 files. Fin_Product, Interm_Product,
Raw_material, and Components.  The linking is as follows.

The level 1 SKU in Fin_Product links to one record type in the Components to
get the level 2 SKU.
The level 2 SKU must link to Interm_Product.
Then, the level 2 SKU links to a second record type in the Components to get
the level 3 SKU.
The level 3 SKU must link to Raw_Materials.

The end result would be to allow a user to view a SKU in Fin_Product and see
specifications of both level 2 SKU and level 3 SKU from Interm_Product and
Raw_Materials, respectively.  I first thought of somehow joining the files
with DDS or SQL but don't know if this might be too complex for that.  I
know I can write an RPG program to do this with chain to the different
levels. However, there are a number of varying requests, i.e. different
reports and screen inquiries with different parameters, that are needed.  It
would be nice to have a way of getting to the needed data at the DB level.

Does anyone have any suggestions?  Would a canned data mining tool work in
this scenario?  Which one?

TIA,
Sam Kanakanui
Borg Systems, Inc.


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---