MVSFORUMS.com

Ranjish

Hi,

I am bot sure if I gave the subject correctly. Sorry if it is not clear. I will come to my problem.

There is a column in a DB2 table with length 3000 which holds some value. We need to know the occurrence of a particular value in the table. This can come multiple times in a row.

eg: ABC122ASASA ABC9383222

In the above value (shown for one row), I need to find out occurence of 'ABC'. But again, I need to find out the occurrence in the whole table.

The requirement was implemented in Cobol and want to cross check in SPUFI. Is there any way of doing this in SQL using SPUFI?

Thanks
Ranjish

Bithead · Posted: Tue Dec 07, 2004 10:27 am Post subject:

Try

SELECT COUNT(*)
FROM MY.DB2TABLE
WHERE MYCOLUMN LIKE '%ABC%'

kolusu · Posted: Tue Dec 07, 2004 10:37 am Post subject:

Bithead,

Count(*) is a column function and I don't think that is what ranjish wants. Ranjish wants to count the occurance of ABC horizontally !!

i.e if the table contains just one row like this

Ranjish · Posted: Tue Dec 07, 2004 10:44 am Post subject:

Bithead,

Yes, my rqmt. is exactly as Kolusu mentioned. Is there any way of doing that through spufi?

regards
Ranjish

kolusu · Posted: Tue Dec 07, 2004 10:57 am Post subject:

Bithead · Posted: Tue Dec 07, 2004 11:12 am Post subject:

Nice!

I believe that this gives the total count:

Ranjish · Posted: Wed Dec 08, 2004 10:14 am Post subject:

Kolusu,

Thank you for the fast reply. It is working perfectly.

regards
Ranjish