Hi,

I wonder if anyone one knows if IDS (9.3) asigns rowids in increasing order?

I mean Always.

In the documentation it i stated that:

"The database server assigns to each row in the rowid column a unique number that remains stable for the life of the row."

But I haven't found any indication that the numbers asigned to the rowdis are always choosed in increasing order.

If anyone know, let me know . I'll appreciate it a lot.


Chucho!



Jean Sagi
jeansagi@myrealbox.com
jeansagi@netscape.net


sending to informix-list

Jean Sagi wrote:
> Hi,
>
> I wonder if anyone one knows if IDS (9.3) asigns rowids in increasing order?
>
> I mean Always.

Short answer: NO! Forget about it.
Regards.

No.

Where in the documentation does it say that?

"Jean Sagi" <jeansagi@myrealbox.com> wrote in message
news:c69l83$lfr$1@terabinaries.xmission.com...
>
> Hi,
>
> I wonder if anyone one knows if IDS (9.3) asigns rowids in increasing
order?
>
> I mean Always.
>
> In the documentation it i stated that:
>
> "The database server assigns to each row in the rowid column a unique
number that remains stable for the life of the row."
>
> But I haven't found any indication that the numbers asigned to the rowdis
are always choosed in increasing order.
>
> If anyone know, let me know . I'll appreciate it a lot.
>
>
> Chucho!
>
>
>
> Jean Sagi
> jeansagi@myrealbox.com
> jeansagi@netscape.net
>
>
> sending to informix-list