My suggestion would be to use the Prime style I-descriptors instead of the cryptic Pick style correlative.
With an I-descriptor you could simply SUM the field. If you could decipher what your correlative does (my guess is reading field 8 of the TWIP file), an appropriate I-descriptor could be made pretty easily. Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Wednesday, September 01, 2004 10:37 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Correlative referencing multi-value field in another file Yes, this is the way it works, unfortunately. What we ended up doing was to change att 8 in WO.COMP.QTY to F;0(TWIP;X;;8);(G0 1);0(TWIP;X;;8);(G1 1);0(TWIP;X;;8);(G2 1);.........;+;+;+;+ etc -Dianne Rod Hills wrote: >We are trying to do a very basic PICK technique of summing a multi-value field >in a F-type correlative. > >However, it appears uniVerse is not putting the multi-values onto it's "stack" >as inividual values, but rather as one entry with the value markers replaced >with blanks. > >Below are two dictionary definitions, the only difference is WO.COMPL.QTY does >a sum as its last step. > >As can be seen by the LIST output, only single-value entries return a non-zero >value. > >Anyone else come across this? And should it be working this way? > >We are on UV10.0.16 and HPUX11i. > >Thanks in advance > >-- Rod Hills ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
