I've come across the same thing .... now I only use the count from EM properties as an approximation. I use select count(*) from either QM or EM if...

We did something like that ..... Used IBM's MQSeries product to transmit data from the web to AS/400 ........ Maybe IBM's WebSphere would help too...

I'm not meaning to run the entire snapshot every night ..... just the transactions .... hmmmmm .....

Thanks for the help !

If there is a main field you would want to know this on the something like this

SELECT fldIwannaC

FROM myTbl

GROUP BY fldIwannaC

HAVING COUNT(fldIwannaC) >...