Hi,
I am trying to query a big table which contains huge data,I just tried to check the no of records of table, i have run the query for COUNT(*) in QMF, But i am not getting the result , i am getting an error -802 ,saying commit frequency must be greater than zero.
Is there any way of getting the count?
I tried in platinum tool also, but its N/A over there in 'No. of rows' field.

Please help me in this regard.

Try using the DB2 CLP.

Andy

Hi Andy, actually I m using zos v8.

Try to use

count_big(*) instead of count(*)

Lenny

Thanks a lot Lenny

Really today I learnt a new thing.

No problem !