Re: ROWIDs and fragmented temporary tables

Yes, I know this, but I'm trying to NOT rewrite the applications. Thank you, Octav Yuri Dovgart wrote: > > <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. -- 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