Re: ROWIDs and fragmented temporary tables

<com@netinfo-moldova.com> wrote in message news:80ogam$kaj$1@nnrp1.deja.com... You must create your tables as CREATE TABLE ... WITH ROWIDS. By default fragmented tables don't have rowid column. ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > Hello, > > > I have a question regarding ROWIDs on fragmented temporary > tables. I've just installed and configured an Informix server (7.30) > and I configured it to use three temporary dbspace. > I've got a surprise discovering that some of applications > use rowid columns on temporary tables. As a result of using > more than one temporary dbspaces the temporary tables > got fragmented and these applications end up with an error > stating that there are no rowids on fragmented tables. > > Is there any ways to handle this issue quickly (Informix Server > parameter on env. variable) ? Of course for now I've > listed just one temporary dbspace in DBSPACETEMP onconfig > parameter and if we'll have to we'll rewrite the application > so it will not use rowid's on temporary tables, but I'm wondering > wether it is a simpler sollution. > > Thank you, > Octav > > > Sent via Deja.com http://www.deja.com/ > Before you buy.