Strange situation - DB2

Posted in 2010

Ravi Shankar Namasivayam — Thu, 22 Jul 2010 06:54:41 -0700 (PDT) — source: Usenet: comp.databases.informix

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?

↪ replying to Ravi Shankar Namasivayam

Everett Mills — Thu, 22 Jul 2010 09:10:09 -0500 — source: Usenet: comp.databases.informix

> -----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 > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list