Hi Rod,
I assist my customers who run both UniVerse and UniData in the Pick
flavor and created the following dict item to SUM the values from another
record:
0001: I (SQL)}}NUMERIC}Y}}}
0002: SUM(TRANS('WO-BOM',F0,3,'X'))
0003: MD4
0004: Test SUM
0005: 8R
0006: S
0007:
WO........ List values Test SUM
1004 5.0000 11.0000
5.0000
1.0000
1021 3.0000 3.0000
1038 1.0000 1.0000
S01011 1.0000 5.0000
1.0000
1.0000
1.0000
1.0000
1055 0.0000
1072 0.0000
Your dict item reminds me of the old PICK days. I still have 1
customer running the PICK operating system.
Have a Great Day!
> Paul Trebbien
> Kore Technologies, Senior Support Tech.
> "Solutions that work. People who care."
> V 858.678.0030 F 858.300.2600 W www.koretech.com
>
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Rod Hills
Sent: Wednesday, September 01, 2004 8:11 AM
To: [EMAIL PROTECTED]
Subject: [U2] Correlative referencing multi-value field in another file
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/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
