Re: Rename Index?

From: QueriX 4GL / Mehdi <mehdi@querix.com> > >Jonathan Leffler wrote: > > > > As Art said, "No". I'll just observe that I put in a feature request, > > oh, 5-10 years ago saying that for every object in the database with a > > name, there should be a RENAME command. They've added RENAME DATABASE > > which is a step in the right direction; now, how about the rest of the > > database -- indexes, constraints, procedures, types, etc. > > > > Of course, my FR went into the FRDB - aka the Black Hole. > > > > Incidentally, I've not used Oracle but I think it has a 'CREATE OR > > REPLACE PROCEDURE' statement which could be useful in Informix, too. > > Similarly for views, too. > >I think we should all vote for Jonathan to be in charge of the future >development of products at Informix. >I personally believe the products would improve that much more, because he >cares. What has Jonathan ever do for you to curse him so? :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Obnoxio The Clown wrote: > From: QueriX 4GL / Mehdi <mehdi@querix.com> > > > >Jonathan Leffler wrote: > > > > > > As Art said, "No". I'll just observe that I put in a feature request, > > > oh, 5-10 years ago saying that for every object in the database with a > > > name, there should be a RENAME command. They've added RENAME DATABASE > > > which is a step in the right direction; now, how about the rest of the > > > database -- indexes, constraints, procedures, types, etc. > > > > > > Of course, my FR went into the FRDB - aka the Black Hole. > > > > > > Incidentally, I've not used Oracle but I think it has a 'CREATE OR > > > REPLACE PROCEDURE' statement which could be useful in Informix, too. > > > Similarly for views, too. > > > >I think we should all vote for Jonathan to be in charge of the future > >development of products at Informix. > >I personally believe the products would improve that much more, because he > >cares. > > What has Jonathan ever do for you to curse him so? :-) > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com Sorry I honestly thought it was good for the Informix users, I never thought of poor Jonathan. I am still confused was my suggestion a curse? -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web) For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------

QueriX 4GL / Mehdi wrote: > > Obnoxio The Clown wrote: > > > From: QueriX 4GL / Mehdi <mehdi@querix.com> > > > > > >Jonathan Leffler wrote: > > > > > > > > As Art said, "No". I'll just observe that I put in a feature request, > > > > oh, 5-10 years ago saying that for every object in the database with a > > > > name, there should be a RENAME command. They've added RENAME DATABASE > > > > which is a step in the right direction; now, how about the rest of the > > > > database -- indexes, constraints, procedures, types, etc. > > > > > > > > Of course, my FR went into the FRDB - aka the Black Hole. > > > > > > > > Incidentally, I've not used Oracle but I think it has a 'CREATE OR > > > > REPLACE PROCEDURE' statement which could be useful in Informix, too. > > > > Similarly for views, too. > > > > > >I think we should all vote for Jonathan to be in charge of the future > > >development of products at Informix. > > >I personally believe the products would improve that much more, because he > > >cares. > > > > What has Jonathan ever do for you to curse him so? :-) > > ______________________________________________________ > > Get Your Private, Free Email at http://www.hotmail.com > > Sorry I honestly thought it was good for the Informix users, I never thought of > poor Jonathan. > I am still confused was my suggestion a curse? Let's see . . . putting a techie into a management position . . . . hmmmmmmmmmmmmmmmm? Depends on the point of view . . . . 8-) -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */