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?

> -----Original Message-----
> From: informix-list-bounces DeleteThis @iiug.org [mailto:informix-list-
> bounces DeleteThis @iiug.org] On Behalf Of Ravi Shankar Namasivayam
> Sent: Thursday, July 22, 2010 8:55 AM
> To: informix-list DeleteThis @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 DeleteThis @iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list