Re: Temp Tables and ROWIDS
It is possible that your temp tables being created in multiple temp dbspaces
thus causing fragmentation. A fragmented table is not created with rowids
unless explicitly defined to do so. You may want to try creating your
temporary table first using the with rowids clause the do a insert into
select from statement. Still some recoding necessary but probably the
easiest to implement.
Joe
----- Original Message -----
From: Wolfgang Zager <zager@compuserve.com>
To: <informix-list@iiug.org>
Sent: Monday, February 07, 2000 4:20 AM
Subject: Temp Tables and ROWIDS
> Hello,
>
> when using IDS 7.31 UC2 we ran into the problem, that the
> server states error -857 (Rowids do not exist on table).
> The code we use something like:
>
> SELECT field1, field2
> FROM stat_table
> WHERE 1 = 2
> INTO TEMP tmp_table>
> ... Insert some data into tmp_table ...
>
> SELECT field1, field2, ROWID FROM tmp_table>
> This works fine on different SE-Engines, as well
> as IDS 7.23 TC24, which we use on Windows-NT.
>
> Why doesn't it anymore work on 7.31 UC2? Does
> anyone know, if it is a bug?
>
> The problem is, that we are not able to
> create a unique index on tmp_table.
>
> Because we are using this way of working a lot of
> times in our applications, we looking for a way
> to make it work again. Otherwise we will have to
> do a lot of recoding.
>
> Wolfgang