467,209 Members | 1,283 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

db2look -tw


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
  • viewed: 3761
Share:
2 Replies
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

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.

Similar topics

3 posts views Thread by dbtoo_dbtoo | last post: by
6 posts views Thread by Lennart Jonsson | last post: by
1 post views Thread by Lyn Duong | last post: by
1 post views Thread by db2group88@yahoo.com | last post: by
8 posts views Thread by db2sysc@yahoo.com | last post: by
2 posts views Thread by shsandeep | last post: by
1 post views Thread by Gregor Kovač | last post: by
1 post views Thread by blaisestephen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.