>I have the following code:
>
>
>
>
>  select distinct tpi_ind;
>    from cdmtpi;
>    order bytpi_ind;
>    into array aindicators
>

And the question is? Do you want to know how many distinct values exist?

select count(distinct tpi_ind)...

Do you want to know how many of each tpi_ind you have?

select tpi_ind, count(*) kount from cdmtpi group by tpi_ind order by tpi_ind ...

If you want only those tpi_ind with a count greater than some value:

select tpi_ind, count(*) kount from cdmtpi group by tpi_ind having kount > 6 order by tpi_ind ...