Creating a file from existing files

[Wayne.Laughton@southcorp.com.au]

--openmail-part-0281c6f3-00000001
Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

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

--openmail-part-0281c6f3-00000001
Content-Type: application/x-openmail-1734; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+Iv/ZAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N
aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAJAAAAENyZWF0aW5nIGEg
ZmlsZSBmcm9tIGV4aXN0aW5nIGZpbGVzAAANAQWAAwAOAAAAzgcHAAgAEQAdABoAAwAvAQEA
gAAATgAAAAQATgAQAC4AV2F5bmUgTGF1Z2h0b24AAE9QRU5NQUlMOldheW5lIExhdWdodG9u
IC93YXRyaGVhdCxyeWRhbG1lcixpcwAAAAAAAAAAAC4WASCAAwAOAAAAzgcHAAgAEQASACQA
AwAuAQEJgAEAIQAAAEMyOTlFMUM3M0UxNkQyMTFBOTFFMDA4MEM3NzUxRDlBABsHAQOQBgAs
AwAAIAAAAAsAAgABAAAACwAjAAAAAAADACYAAAAAAAsAKQAAAAAAAwAuAAAAAAADADYAAAAA
AEAAOQAAd+ciQqq9AR4AQgABAAAADwAAAFdheW5lIExhdWdodG9uAABAAEgA4PCWI0KqvQEe
AHAAAQAAACQAAABDcmVhdGluZyBhIGZpbGUgZnJvbSBleGlzdGluZyBmaWxlcwACAXEAAQAA
ABYAAAABvapCIt7H4ZnEFj4R0qkeAIDHdR2aAAAeABoMAQAAAA8AAABXYXluZSBMYXVnaHRv
bgAAAgEdDAEAAAAuAAAAT1BFTk1BSUw6V0FZTkUgTEFVR0hUT04gL1dBVFJIRUFULFJZREFM
TUVSLElTAAAAHgAeDAEAAAAJAAAAT1BFTk1BSUwAAAAAHgAfDAEAAAAlAAAAV2F5bmUgTGF1
Z2h0b24gL3dhdHJoZWF0LHJ5ZGFsbWVyLGlzAAAAAB4AQhABAAAAAQAAAAAAAAADAIAQ////
/0AABzBA8CafQKq9AUAACDBA8CafQKq9AQsAAIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAA
AAAAAwACgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAWACCAGAAAAAADAAAAAAAAA
RgAAAABShQAAdBAAAB4AJYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABQAAADguMDIA
AAAAAwAmgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALAC+ACCAGAAAAAADAAAAAAAAA
RgAAAAAOhQAAAAAAAAMAMIAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAygAggBgAA
AAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAEGACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAA
AAEAAAAAAAAAHgBCgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AQ4AI
IAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAAeAD0AAQAAAAEAAAAAAAAAAwAN
NP03AADHdw==

--openmail-part-0281c6f3-00000001--

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.