By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,021 Members | 912 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,021 IT Pros & Developers. It's quick & easy.

db2look -tw

P: n/a

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

Jun 29 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Jun 30, 3:01 am, Justin <kfw...@hotmail.comwrote:
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.

Jun 30 '07 #2

P: n/a

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 <tonk...@jp.ibm.comwrote:
On Jun 30, 3:01 am, Justin <kfw...@hotmail.comwrote: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.

Jul 12 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.