470,636 Members | 1,526 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

How to extract definition of nicknames in DB2 version 7

Hi,

We have DB2 version 7 fixpak 14 on AIX 5.1. We have nicknames to
another RDBMS tables. These nicknames have views and specification only
indexes.

I would like to know how we can extract the definition of these
nicknames and related objects. db2look does not seem to have any option
to extract this information. I tried the command "db2look -d <DB_NAME>
-e". This does not return the nickname definitions.

Your help is much appreciated.

Thanks,
Prasad.

Nov 28 '06 #1
1 2150
Prasad wrote:
Hi,

We have DB2 version 7 fixpak 14 on AIX 5.1. We have nicknames to
another RDBMS tables. These nicknames have views and specification only
indexes.

I would like to know how we can extract the definition of these
nicknames and related objects. db2look does not seem to have any option
to extract this information. I tried the command "db2look -d <DB_NAME>
-e". This does not return the nickname definitions.

Your help is much appreciated.
As I tried to answer in the other thread: Either you move to V8 (or higher),
or you extract the information manually from the DB2 catalog views.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Don Crossman | last post: by
1 post views Thread by Anton Pervukhin | last post: by
3 posts views Thread by Jeronimo Bertran | last post: by
1 post views Thread by dbtoo_dbtoo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.