DOH!

I've never done something like that - lol

-----Original Message-----
From: owner-informix-list@iiug.org [mailtowner-informix-list@iiug.org] On Behalf Of Chris S
Sent: Tuesday, August 02, 2005 1:05 PM
To: informix-list@iiug.org
Subject: Re: SERIAL8 on a Fragmented Table

I think I found my problem and it's not really a problem at all. Go
figure.

During my "testing" I was doing an "SQL> select first 100 * from
testtable" and looking at the output of that. It must have just been
grabbing data from only one of the fragments. When I add an order by
SERIAL column it spits back the serial values incremented by one like I
expected. Thanks for any responses.

Live and learn I guess.

--
Chris




sending to informix-list

Sometimes I just have to ask the question so I can find my own bonehead
mistake. At least I didn't spend to long on it. :-)