Distributing amounts to more than one record in QUIZ

[Pickering, John (NORBORD)]

Boris

You can easily get the 200 remaining in your example:

>footing at s-partnum &
>  i-qty of inventory subtotal negative &
>    initial s-qty of subfile

Stopping when you get to zero may be a trick.

This would be much more easily accomplished with Qtp and a few tempoary
items :-)

John Pickering
Toronto

-----Original Message-----
From: Boris Kortiak
To: powerh-l@lists.swau.edu
Sent: 02/17/2000 11:24 AM
Subject: Distributing amounts to more than one record in QUIZ

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.