Re: Temp Tables and ROWIDS

It could be you have more than one temporary dbspaces listed in DBSPACETEMP. Just list one temporary dbspace there and I think your code will work. But, of course you should try rewriting the application (if possible) to not use ROWIDs in temporary tables. Of course you could use the WITH ROWIDs clause on CREATE TEMP TABLE statement (as I remember you can'tuse this clause on INTO TEMP). Regards, Octav Wolfgang Zager wrote: > > 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 -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com