Re: [U2] Count question

2010-01-07 Thread Anthony W. Youngman
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

Re: [U2] Count question

2010-01-07 Thread Boydell, Stuart
@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

[U2] Count question

2010-01-06 Thread Ed Hess
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.

Re: [U2] Count question

2010-01-06 Thread Kevin King
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

Re: [U2] Count question

2010-01-06 Thread Boydell, Stuart
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

Re: [U2] Count question

2010-01-06 Thread Marc Rutherford
/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

Re: [U2] Count question

2010-01-06 Thread Boydell, Stuart
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

Re: [U2] Count question

2010-01-06 Thread Bernard Lubin
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

2010-01-06 Thread Marc Rutherford
: 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

Re: [U2] Count Question

2010-01-06 Thread Brutzman, Bill
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