In message
d85db451e1913e4d9889cfb25543b24701975...@auexci01.ad.internal,
Boydell, Stuart stuart.boyd...@spotless.com.au writes
Whoops - forgot the reuse function:
LIST MY.FILE EVAL SUM(GTS(MY.MV.FIELD,REUSE(0)))
In this instance you might need SUM() twice ...
Note that when the example was
@listserver.u2ug.org
Subject: Re: [U2] Count question
In message
d85db451e1913e4d9889cfb25543b24701975...@auexci01.ad.internal,
Boydell, Stuart stuart.boyd...@spotless.com.au writes
Whoops - forgot the reuse function:
LIST MY.FILE EVAL SUM(GTS(MY.MV.FIELD,REUSE(0)))
In this instance you might need SUM
Hi all,
Using UniVerse 9.6 on AIX4.1,
I'm trying to write a routine to count the number of occurrences of
values than 0, for example,
against this attribute:
0011: 4|0|0|0}4|23|4|0
I'd like to return a value of '4' for the 4 values 0.
Not having much luck with COUNT or DCOUNT.
Are those the real delimiters? I would think you're going to need a couple
of loops to do what you want. COUNT will only count the number of times a
character/string appears inside of another one and DCOUNT counts the number
of delimited strings.
Perhaps something like this:..assuming VALUES is
LIST MY.FILE EVAL SUM(GTS(MY.MV.FIELD,0))
Stuart Boydell
-Original Message-
Hi all,
Using UniVerse 9.6 on AIX4.1,
I'm trying to write a routine to count the number of occurrences of
values than 0, for example,
against this attribute:
0011: 4|0|0|0}4|23|4|0
I'd like to
/Analyst
Advanced Bionics LLC
661) 362 1754
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Wednesday, January 06, 2010 3:04 PM
To: U2 Users List
Subject: Re: [U2] Count question
Are those the real
Whoops - forgot the reuse function:
LIST MY.FILE EVAL SUM(GTS(MY.MV.FIELD,REUSE(0)))
eg
LIST GRTRANS EVAL SUM(GTS(REC.QTY,REUSE(0))) FMT 10R REC.QTY
G38781801 1
G46781921 2
18675004 1
on the status
of MORE.DATA
Regards
Bernard Lubin
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Hess
Sent: Thursday, 7 January 2010 9:46 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Count question
Hi all
: Re: [U2] Count question
Whoops - forgot the reuse function:
LIST MY.FILE EVAL SUM(GTS(MY.MV.FIELD,REUSE(0)))
eg
LIST GRTRANS EVAL SUM(GTS(REC.QTY,REUSE(0))) FMT 10R REC.QTY
G38781801 1
G46781921 2
18675004 1
Hess
Sent: Wednesday, January 06, 2010 5:46 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Count question
Hi all,
Using UniVerse 9.6 on AIX4.1,
I'm trying to write a routine to count the number of occurrences of
values than 0, for example,
against this attribute:
0011: 4|0|0|0}4|23|4|0
10 matches
Mail list logo