rename contraints...

Hi All, IDS 7.31 - IDS 11.50 There is any way to rename a constraint?? without drop and create? ________________________________________________________________________________ ____ Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

Not that I know of. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Mar 29, 2010 at 9:53 AM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Hi All, > > IDS 7.31 - IDS 11.50 > > There is any way to rename a constraint?? without drop and create? > > > > ________________________________________________________________________________ ____ > Veja quais são os assuntos do momento no Yahoo! +Buscados > http://br.maisbuscados.yahoo.com > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174478f4f06b4e0482f271d8

Sharing a little more about the situation and what I got. Some tables must be renamed and the constraint too, to keep the company standard names . A alternative for this limitation, is create an index with the same configuration over the constraint to reuse the implict index, drop the constraint and recreate it reusing the explict index, but this is not possible, give error "-350 Index already exists on the column (or on the set of columns)" when try create the index over a constraint. But, if before the first time you create the constraint, you already have the explicit index, this works, because the explicit index is already there. Just drop the constraint and recreate it with the new name. The performance limitation is over a heavy read executed for some reason until constraint created (I don't check where, index or table) . But no sort and write are executed, what is some advantage. Now I have a new item for my next IIUG survey , add RENAME CONSTRAINT support. Cesar --------------------- Hi All, IDS 7.31 - IDS 11.50 There is any way to rename a constraint?? without drop and create?