Distributing amounts to more than one record in QUIZ

[Boris Kortiak]

Hi,

I'm running QUIZ on MPE/iX and can't figure out how to distribute amounts from a single input record to multiple matching records.

I have a subfile which is made up of S-PARTNUM and S-QTY.  This matches to a inventory file which has a key of I-PARTNUM and I-LOCATION and an I-QTY field.  What I need to do is reduce the amount in the S-QTY record by each I-PARTNUM, I-LOCATION combination.

Say in the first subfile record I have:
	S-PARTNUM = "P" and S-QTY = 500
And the inventory has matching I-PARTNUM records of:
	I-LOCATION = "L1" and I-QTY = 200
	I-LOCATION = "L2" and I-QTY = 100
I want to report that I have a remaining quantity of 200 (S-QTY - (I-QTY(L1) + I-QTY(L2))

I also want to stop processing when the remaining quantity is <= zero and go on to the next subfile record.

Is this doable in QUIZ?  Do I have do fall back to some 3GL?

Any hints greatly appreciated.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.