Hi folks,

is there a command which can show the definition of a view (i.e. show
the actual SQL that created in the view)?

much thanks
ME

Yes you can.

If you are using a GUI interface (java)
just rklick on the view, select change
and rip off the creation code.

On Unix/AIX/Linux you can use
the db2look utility and specify
the view as a table.

BOW

The db2look utiliy will produce DDL for a database, including views (with the -e option). See the Command Reference for information on the parms to use.

What I meant is that
the db2look utility treats
views as tables, so use
the -t <myview> switch
to limit your output.

SELECT TEXT
FROM SYSCAT.VIEWS
WHERE VIEWNAME = 'myview' and viewschema = 'myschema'

Nice one, hadn't seen that before!