Creating a file from existing files

[dmaclary@wellmanage.com]

Here's one possible solution...

1. Access the part-detail file and create an indexed subfile, where the
index always has a constant
    value, say 1.  The subfile should contain the index, the part-number,
and anything else from part-
    detail that you'll need later.

2. Access the technician file and link (1) to the index of the subfile from
step 1. This will link each
   record from the input file (technician) to ALL records in the subfile.
You now have everything that
   you need to update tech-part-file!

Regards,
David Maclary

> ----------
> From: 	Wayne Laughton
> Sent: 	Wednesday, July 08, 1998 3:29 AM
> To: 	powerh-l@lists.swau.edu
> Subject: 	Creating a file from existing files
> 
> I need to populate the fields of a file from the contents of 2 others. 
> The file to be populated is empty and has a key to each of the other 
> files. A smaple of each layout is a follows:-
> 
> PART-DETAIL FILE
> 
> part-number       x(10)  key
> part-desc           x(20)
> ...........
> 
> TECHNICIAN FILE
> 
> tech-id               x(6)   key
> tech-name         x(20)
> ..........
> 
> TECH-PART-FILE
> part-number       x(10)  key
> tech-id               x(6)   key
> qoh                    9(6)
> .............
> 
> The PART-DETAIL file has records as does the TECHNICIAN file. I need to 
> be able to populate the TECH-PART FILE with a combination of all TECHs 
> and all PARTS.
> 
> How can this be done in Powerhouse? Effectively I need to be able to 
> read sequentially thru the TECHNICIAN file and for each TECH retrieve 
> sequentially all PART-DETAIL records and combining the TECH and PART 
> numbers plus static data, populate TECH-PART file.
> 
> This is on an IMAGE database on HP3000.
> 
> Any help greatly appreciated.
> 
> Regards,
> Wayne Laughton
> 
> Manager, Business Systems
> Southcorp Water Heaters Australia
> --------------------------------------------------
> Phone: + 61 2 9684 9140
> Fax : + 61 2 9684 4270
> Mobile: 0412 254 484
> Inet :  wayne.laughton@southcorp.com.au
> Mail: Southcorp Water Heaters Australia
>  P.O. Box 6 
>  Rydalmere NSW 2126
>  AUSTRALIA
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.