SEO

#1 (**permalink**) 04-19-2008, 08:03 PM

Hello,

In many DMBS we ve got the DESCRIBE statement.

I've got an informix view and I want to see the code that define my view.
I tried DESCRIBE <table> in dbaccess but an error occured.

I don't want to see the columns but the code stored in the view.

Perhaps it is stored in a systeme table?

Xavier

#2 (**permalink**) 04-19-2008, 08:03 PM

To see the view, use dbschema; e.g.,

dbschema -d dbname -t viewname

Xavier Autret wrote:

>Hello,
>
>In many DMBS we ve got the DESCRIBE statement.
>
>I've got an informix view and I want to see the code that define my view.
>I tried DESCRIBE <table> in dbaccess but an error occured.
>
>I don't want to see the columns but the code stored in the view.
>
>Perhaps it is stored in a systeme table?
>
>Xavier
>
>

#3 (**permalink**) 04-19-2008, 08:03 PM

On Tue, 27 Jan 2004 05:24:44 -0500, Xavier Autret wrote:

> Hello,
>
> In many DMBS we ve got the DESCRIBE statement.
>
> I've got an informix view and I want to see the code that define my view. I
> tried DESCRIBE <table> in dbaccess but an error occured.
>
> I don't want to see the columns but the code stored in the view.

Use the dbschema commandline utility:

dbschema -d <database> [-t <table/view>] [schemafile]

> Perhaps it is stored in a systeme table?

Yes. Look in sysviews joined to systables:

select viewtext
from systables st, sysviews sv
where st.tabid = sv.tabid
and st.tabname = "myviewname"
order by seqno;

Art S. Kagel

> Xavier

#4 (**permalink**) 04-19-2008, 08:03 PM

Check out <table> -> <info> . This will display similar information as the
Describe command.

N.B. the describe sommand is actually a valid sql command that is usually
used with SCLDA structures that is used by dynamic queries. These are
required by things such as ODBC and JDBC drivers to provide a generic
interface to a DBMS.

The usage of dbschema will return the definition of the view as well as
which tables make up the view.

"Xavier Autret" <xav_x@noos.fr> wrote in message
news:f76de91b.0401270224.59626998@posting.google.c om...
> Hello,
>
> In many DMBS we ve got the DESCRIBE statement.
>
> I've got an informix view and I want to see the code that define my view.
> I tried DESCRIBE <table> in dbaccess but an error occured.
>
> I don't want to see the columns but the code stored in the view.
>
> Perhaps it is stored in a systeme table?
>
> Xavier

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode