Hi

When I want to get the ddl for a table, i use db2look -d dbname -e -t
tabname.
Why does this produce all ddl for functions, federated objects and all
other unwanted stuff.

Is there a way to turn this off ???

Thanks
Lyn

If you're on DB2 V8 you can use the -noview and -nofed switches for
db2look. Not sure if they can be used from within the control center,
on the command line they work. I think ddl generation for functions
cannot be suppressed, since they could be used within a create table
statement (eg. for generated columns)

HTH
Joachim

lynd@tablimited.com.au (Lyn Duong) wrote in message news:<8d1cda6d.0405132201.3b22cccd@posting.google. com>...[color=blue]
> Hi
>
> When I want to get the ddl for a table, i use db2look -d dbname -e -t
> tabname.
> Why does this produce all ddl for functions, federated objects and all
> other unwanted stuff.
>
> Is there a way to turn this off ???
>
> Thanks
> Lyn[/color]