Re: Temporary dbspace

On Fri, 4 Nov 2005 14:53:44 -0000, "Doug Lawry" <lawry@nildram.co.uk> wrote: >Hi Malcolm. > >There is a "gotcha" here. I was involved with a single temp dbspace system (I >think you know which one!) which behaved differently if a second was added. To >illustrate, if you ran > > create temp table temp_test (number integer);> > insert into temp_test values (1); > insert into temp_test values (2); > insert into temp_test values (3); > insert into temp_test values (4);> > select * from temp_test;> >with one temp dbspace you got "1, 2, 3, 4", as you would expect, but with two >you got "1, 3, 2, 4", which totally confused the 4GL application! This is >presumably because it automatically striped across the two dbspaces. No, it's because you never specified an "order by" clause, thus, the returned rows could be in any order . . . . JWC