db2look -tw

[Justin]

Is there a way to get the ddl for a subset of tables?

In this case, get all the tables beginning with emp from the sample
db?

Example
db2look -e -tw emp* -d sample

[Tonkuma]

On Jun 30, 3:01 am, Justin <[e-mail]:

Is there a way to get the ddl for a subset of tables?

In this case, get all the tables beginning with emp from the sample
db?

Example
db2look -e -tw emp* -d sample

In -tw, pattern should specify same as LIKE, which means that '_' for
any one character and '%' for any number of any characters.
I thought that you can try
db2look -e -tw emp% -d sample
I tried it. But only EMP was generated.
So, I tried
db2look -e -tw emp%% -d sample
Then generated whar I expected(Many emp...).

There may be some problem in db2look command or I still didn't
understand enough the functionalities of the command.
Another thought, I issued the command from Command Editor. So, it may
be Command Editor's functionality.

[Justin]

I was able to use -tw emp% and it returned all the objects that began
with emp.

Thanks.

On Jun 30, 1:22 pm, Tonkuma <[e-mail]:

On Jun 30, 3:01 am, Justin <[e-mail]:Is there a way to get the ddl for a subset of tables?

In this case, get all the tables beginning with emp from the sample
db?

Example
db2look -e -tw emp* -d sample

In -tw, pattern should specify same as LIKE, which means that '_' for
any one character and '%' for any number of any characters.
I thought that you can try
db2look -e -tw emp% -d sample
I tried it. But only EMP was generated.
So, I tried
db2look -e -tw emp%% -d sample
Then generated whar I expected(Many emp...).

There may be some problem in db2look command or I still didn't
understand enough the functionalities of the command.
Another thought, I issued the command from Command Editor. So, it may
be Command Editor's functionality.