Brian:
This is an old Pick trick. The 1st correlative always returns the first
value. The 2nd correlative always returns the last.
When I converted from D3 to UniData I changed these kinds of things to:
First value:
002 EXTRACT ( ACCTS, 1, 1, 0 )
Last value:
002 EXTRACT ( ACCTS, 1, 0, 0 ) ; EXTRACT ( @1, 1, DCOUNT ( @1, @VM ), 0 )
However, I thought UniVerse handled these kinds of correlatives. When I
first upgraded to UniVerse I think I remember testing these dictionaries
and they worked. Hmmmm.
HTH,
Bill
------------------------------------------------------------------------
Brian Leach said the following on 5/24/2010 2:31 AM:
Jim
First value (a number of ways but this will work):
002 9
008 F;9R
No, this means 'repeat the value in field 9 for the depth of the expression'
e.g. if you wanted to multiply each value in a multivalued field with a
single valued field to get a multivalued result.
Last value:
002 9
008 F;9;P;S;_
Not sure what you're trying to achieve here. It's equivalent to @RECORD<9> -
SUM(@RECORD<9>)..
Or am I missing something?
Brian
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of James Patrick
Volkman
Sent: 24 May 2010 1:58 AM
To: [email protected]
Subject: [U2] Question on Dictionary Items
Does anyone happen to know why these wouldn't work in Universe?
First value (a number of ways but this will work):
002 9
008 F;9R
Last value:
002 9
008 F;9;P;S;_
I can use an I-Type but I was hoping to translate off those values.
Jim Volkman
http://www.linkedin.com/in/jamesvolkman
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.819 / Virus Database: 271.1.1/2892 - Release Date: 05/23/10
19:26:00
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
