Equally, if you don't want to extract the view definitions from the
metadata for the entire database, the following works too:

isql -x <database> -user xxx -password yyyyy

SQL> output view_source.txt;
SQL> show view <view_name>;
SQL> (repeat for all views)
SQL> exit;

The file view_source.txt now has details.


Cheers,
Norman.


--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767