Re: [U2] Correlative referencing multi-value field in another file

[Dianne Ackerman]

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
    WO.COMPL.QTY
0001 A
0002 0
0003 Wo Compl}Total
0004
0005
0006
0007
0008 F;0;(G0*1);(TWIP;X;;8);S
0009 R
0010 8
    WO.QTY.COMPL
0001 A
0002 0
0003 Wo Qty Compl
0004
0005
0006
0007
0008 F;0;(G0*1);(TWIP;X;;8)
0009 R
0010 12
LIST WIPOPERACT WO.COMPL.QTY WO.QTY.COMPL 10:05:27am  31 Aug 2004  PAGE    1
WIPOPERACT Wo Compl Wo Qty Compl
          Total...
89783*560         4            4
89433*111         0         14 1
78574*370         0    3 5 6 1 5
84804*780         0  2 2 3 3 5 3
88810*070         0
R7735*380         0       15 2 1
89922*630         0
60330*001         0
79101*000         0 18 60 5 2 10
                    3 2
90032*050         0
82930*110         0
88671*001      2937         2937
90449*260         0     3 20 4 3
60268*790         0
60129*720         0
79312*380         2            2
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/