Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2009
    Posts
    6

    Unanswered: -802 error for count(*) query for a DB2 table

    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.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Try using the DB2 CLP.

    Andy

  3. #3
    Join Date
    Aug 2009
    Posts
    6
    Hi Andy, actually I m using zos v8.

  4. #4
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963
    Try to use

    count_big(*) instead of count(*)

    Lenny

  5. #5
    Join Date
    Aug 2009
    Posts
    6
    Thanks a lot Lenny

    Really today I learnt a new thing.

  6. #6
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963
    Quote Originally Posted by srilata83
    Thanks a lot Lenny

    Really today I learnt a new thing.
    No problem !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •