Re: Views

Posted in 2001

Brett Geer — Fri, 16 Feb 2001 08:22:18 +0200 — source: Informix-list mailing list archive (1991-1998)

Without the source that created it you are kinda screwed. Do a dbschema and edit that, then recreate it. I'm not sure if you can alter them with an alter table command, never tried. brett Martyn Shiner wrote: > > I have a db that has several views (virtual tables) set up. How do I find > out what the SQL statment is that created the view? Can I edit this or do I > have to drop the table and set it up again? > > Informix version is 7.20.UE2 > > Regards > Martyn -- ----------------------------------------------------------------- Brett's 13th law of UNIX administration... The 13th sucks, we'll skip this one ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- The little voices are talking to me again, telling me of a long forgotten rhyme... the Rhyme of the Ancient Sysadmin # ps -ef | kill -9 `awk '/albatross/{print $2}'` -----------------------------------------------------------------

↪ replying to Brett Geer

Martyn Shiner — Fri, 16 Feb 2001 12:04:07 -0000 — source: Informix-list mailing list archive (1991-1998)

Yeah - I guessed I'd need the source. As you and others have said the dbSchema gives me the info I need and I can drop and recreate. Guess I was lookinging for a Q&D way since I'm lazy <g> Regards Martyn Brett Geer <brett@brabys.co.za> wrote in message news:96ii9g$f0a$1@news.xmission.com... > > Without the source that created it you are kinda screwed. Do a > dbschema and edit that, then recreate it. I'm not sure if you can > alter them with an alter table command, never tried. > > brett > > Martyn Shiner wrote: > > > > I have a db that has several views (virtual tables) set up. How do I find > > out what the SQL statment is that created the view? Can I edit this or do I > > have to drop the table and set it up again? > > > > Informix version is 7.20.UE2 > > > > Regards > > Martyn > > -- > > ----------------------------------------------------------------- > Brett's 13th law of UNIX administration... > The 13th sucks, we'll skip this one > ----------------------------------------------------------------- > Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. > Tel. +27 31 717 4000 Direct. +27 31 717 4146 > Fax. +27 31 717 4001 > ----------------------------------------------------------------- > The little voices are talking to me again, telling me of a long > forgotten rhyme... the Rhyme of the Ancient Sysadmin > # ps -ef | kill -9 `awk '/albatross/{print $2}'` > -----------------------------------------------------------------