Posted: Thu Aug 20, 2009 4:21 pm Post subject: -802 error for count(*) query for a DB2 table
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.
My problem is solved now.
Actually the result of my query (i.e. No.of records in my table ) is out of range, it was crossing the limit ,so i was getting -802 error.
Now i modified the query as COUNT_BIG(*) and getting the actual result.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum