Re: Strange situation - DB2

Posted in 2010

Brucemarchu@aol.com — Thu, 22 Jul 2010 19:32:07 EDT — source: Usenet: comp.databases.informix

Everett, Try checking your indexes to see if any are corrupted. Bruce = = = = > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Ravi Shankar Namasivayam > Sent: Thursday, July 22, 2010 8:55 AM > To: informix-list@iiug.org > Subject: Strange situation - DB2 > > 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 > _______________________________________________