MVSFORUMS.com

[satyenderd]

Hi All,

Herein I am getting a problem.

I am quering a table in the below mentioned way:

SELECT COUNT(*)
FROM
TABLE1;
---------+---------+---

---------+---------+---
0



SELECT *
FROM
TABLE1;
---------+---------+---------+---------+---------+---------+---
RID OPSEQ OPCODE OPCOMB OPHOURS OPTECHID
---------+---------+---------+---------+---------+---------+---
1 1 860991 1.5 709051650
2 1 001013 2.0 533730792
3 1 001013 2.0 533730792


and I am getting the data when I am using the above query with Select * but not giving the count if i am giving SELECT COUNT(*)

Please suggest me.
_________________
Satya

[satyenderd]

found the answer..
_________________
Satya

[Terry_Heinze]

Please share the solution for our benefit.
_________________
....Terry

[satyenderd]

Terry,

I was asking if anyone found the answer. Sorry, If it meant that I found the answer.

What I did was I ran Runstats.
But no effect.
_________________
Satya

[jsharon1248]

If you get 3 rows in the SELECT *, you should get 3 as the result of SELECT COUNT(*). I saw something similar a long time ago with a huge table that was resolved by running a reorg.

[satyenderd]

Thanks I will reorg and see if the problem gets solved.
_________________
Satya