Views
Martyn Shiner, on IDS 7.20.UE2, asked how to find the SQL that created a view and whether it can be edited. Obnoxio The Clown suggested dbschema, then dropping and recreating the view. Flavio Gattari gave a query joining systables and sysviews to list view text (viewtext by seqno). Martyn said he would try it.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
In the year of Our Lord Thu, 15 Feb 2001 12:07:56 -0000, "Martyn Shiner"
<nospammartyn.shiner@nospambff-nonwovens.com> spake, saying:
>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?
dbschema?
Drop and recreate.
Martyn Shiner ha scritto nel messaggio <96ggo6$1qm9$1@slrn.eurobell.net>...
>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
>
>
>
>
select a.tabname, b.seqno , b.viewtext
from systables a, sysviews b
where a.tabid = b.tabid
and a.tabid > 99
order by 1, 2
it gives you all your views text; you can filter it by view name
flavio gattari
Thanks for that - I'll give it a try
Martyn
Flavio Gattari <fgattari@datamat.it> wrote in message
news:96gqc1$5a7u$1@stargate1.inet.it...
>
> Martyn Shiner ha scritto nel messaggio
<96ggo6$1qm9$1@slrn.eurobell.net>...
> >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
> >
> >
> >
> >
>
> select a.tabname, b.seqno , b.viewtext
> from systables a, sysviews b
> where a.tabid = b.tabid
> and a.tabid > 99
> order by 1, 2>
> it gives you all your views text; you can filter it by view name
>
> flavio gattari
>
>
>