novaBBS - comp.sys.tandem - Enform count()

Enform count()

<4c528158-f11b-4592-9a7c-459b037f34efn@googlegroups.com>

https://www.novabbs.com/computers/article-flat.php?id=668&group=comp.sys.tandem#668

X-Received: by 2002:a37:5ac1:0:b0:75e:c6ad:c98 with SMTP id o184-20020a375ac1000000b0075ec6ad0c98mr24513qkb.13.1690182129365;
Mon, 24 Jul 2023 00:02:09 -0700 (PDT)
X-Received: by 2002:a25:489:0:b0:d09:b19:fe2c with SMTP id 131-20020a250489000000b00d090b19fe2cmr30014ybe.12.1690182129030;
Mon, 24 Jul 2023 00:02:09 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Mon, 24 Jul 2023 00:02:08 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=185.123.143.117; posting-account=FsOzUgoAAADuP58JBN_xTYTjSsXmF-YQ
NNTP-Posting-Host: 185.123.143.117
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <4c528158-f11b-4592-9a7c-459b037f34efn@googlegroups.com>
Subject: Enform count()
From: nsgar...@gmail.com (Mester Pandele)
Injection-Date: Mon, 24 Jul 2023 07:02:09 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1280

by: Mester Pandele - Mon, 24 Jul 2023 07:02 UTC

Hello,

Does anybody know how can I count 'val' values over by-item with Enform count function, but only the distinct values? Like the SQL count(distinct...).

for ex.

Val1 - group1
val1 - group1
val2 - group1

Enform count(val over group)=3 although there are only 2 distinct values.
Thanks a lot,
pandele

Re: Enform count()

<u9m9av$npp6$1@dont-email.me>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=669&group=comp.sys.tandem#669

copy link Newsgroups: comp.sys.tandem

Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: inva...@nowhere.com (JShepherd)
Newsgroups: comp.sys.tandem
Subject: Re: Enform count()
Date: Mon, 24 Jul 2023 16:36:48 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 43
Message-ID: <u9m9av$npp6$1@dont-email.me>
References: <4c528158-f11b-4592-9a7c-459b037f34efn@googlegroups.com>
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
Injection-Date: Mon, 24 Jul 2023 16:36:48 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="f71ebd0eddad0229c181862451ed734d";
logging-data="780070"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+/j7IDGWv/uWIuiKs9u/X8sQQyRdriSaI="
Cancel-Lock: sha1:7R8BC+BAIpJSBlCZ8aVzqBYUMhQ=

by: JShepherd - Mon, 24 Jul 2023 16:36 UTC

In article <4c528158-f11b-4592-9a7c-459b037f34efn@googlegroups.com>,
nsgardek@gmail.com says...
>
>Hello,
>
>Does anybody know how can I count 'val' values over by-item with Enform
count fu
>nction, but only the distinct values? Like the SQL count(distinct...).
>
>for ex.
>
>Val1 - group1
>val1 - group1
>val2 - group1
>
>Enform count(val over group)=3 although there are only 2 distinct values.
>Thanks a lot,
>pandele

Somthing like this ?

Record INTREC.
02 PRIKEY Type Binary 64.
02 JTS1 Type Binary 64.
02 JTS2 Type Binary 64.
02 I32S Type Binary 32.
02 I32U Type Binary 32 Unsigned.
02 I16S Type Binary 16.
02 I16U Type Binary 16 Unsigned.
End

>list by i16u as i12
> count (i16u over i16u);
COUNT
I16U I16U
------------ --------------
43140 1
57344 2

I'll say it again for the logic impaired. -- Larry Wall

computers / comp.sys.tandem / Enform count()

Subject	Author
Enform count()	Mester Pandele
Re: Enform count()	JShepherd