RE: MIDRANGE-L Digest V3 #963

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

Sam Kanakanui wrote:

>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.
-snip-
>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.  
-snip-
>Does anyone have any suggestions?  Would a canned data mining tool work in
>this scenario?  Which one?

Alan mentioned Query (a canned tool) but you felt it wasn't appropriate.  I
guess if you have varied requirements (one user wants to see only levels 1
and 2 but another user wants to see all 3) you will have to make several
queries or programs.

You can prototype a solution using query and then convert it to query
management, HLL or keep the query and add a JOIN to a file where your user
puts SKU 1  (with DFU if need be.)  You'd end up with a query that JOINs the
level 1 SKU input file with FIN_PRODUCT with level 2 SKU in INTERM_PRODUCT
with level 3 SKU in RAW_MATERIALS and so forth.  This should work out pretty
well if you are not an application programmer.

Personally (as an RPG programmer) I'd write a couple of subfile programs and
do the BOM explosion myself - if only to keep the returned JOIN record from
being several thousand bytes wide.  Wrap the lot in a simple menu and you
should be set to go.

Buck Calabro
Aptis; Albany, NY
"Nothing is so firmly believed as
 that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.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
+---