I was able to see certain records when I did SELECT * FROM T1; When I
did SELECT * FROM T1 WHERE EMP_ID = '1234'; 1234 being taken from
output of the first query, returned no rows.

I did REORG on T1 and SELECT * FROM T1; did not show 1234 employee id
in the entire output.

Why 1234 showed up at first place?

If, as the subject line suggests, you are using DB2, you'll likely get a better answer in a DB2 forum. Best guess is that either EMP_ID isn't a numeric field or that the 1234 you saw in the query returning every row has spaces or something in it so that '1234' <> '1234 '.

--EEM

Everett,

Try checking your indexes to see if any are corrupted.


Bruce
= = = =


If, as the subject line suggests, you are using DB2, you'll likely get a
better answer in a DB2 forum. Best guess is that either EMP_ID isn't a
numeric field or that the 1234 you saw in the query returning every row has
spaces or something in it so that '1234' <> '1234 '.

--EEM
> _______________________________________________

From: Brucemarchu (AT) aol (DOT) com [mailto:Brucemarchu (AT) aol (DOT) com]
Sent: Thursday, July 22, 2010 6:32 PM
To: Everett Mills; informix-list (AT) iiug (DOT) org
Cc: bmarchu (AT) aol (DOT) com
Subject: Re: Strange situation - DB2

Everett,
*
Try checking your indexes to see if any are corrupted.*
*
*
Bruce
= = = =

I wasn't the one having the problem, Ravi was. Since he hasn't responded back, I'll assume he took my first suggestion and asked his question in a DB2 forum.

--EEM
*

If, as the subject line suggests, you are using DB2, you'll likely get a better answer in a DB2 forum.* Best guess is that either EMP_ID isn't a numeric field or that the 1234 you saw in the query returning every row has spaces or something in it so that '1234' <> '1234 '.

* * * * --EEM
> _______________________________________________