Re: SYSCOLUMNS.CURRENT_ROWS oddity...

[Charles Wilt <charles.wilt@xxxxxxxxx>]

How many actual distinct values are there?

select count(distinct cmcus#)
from qs36F.cusmasp;


Charles


On Wed, Jan 20, 2021 at 12:03 PM Robert Rogerson <rogersonra@xxxxxxxxx>
wrote:

> Hi All,
>
> When running this query I don't understand why there are more distinct
> values than rows.
>
> SELECT column_name, current_rows, number_distinct_values
>   FROM syscolumnstat
>  WHERE table_schema = 'QS36F'
>    AND table_name = 'CUSMASP'
>    AND column_name = 'CMCUS#';
>
> COLUMN_NAME CURRENT_ROWS NUMBER_DISTINCT_VALUES
> CMCUS# 716 724
> I've tried searching on Google and the IBM site but couldn't find any
> explanation.
>
> Has anyone seen this and can explain it?
>
> Thanks,
>
> Rob
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com