How to extract definition of nicknames in DB2 version 7

[Prasad]

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.

[Knut Stolze]

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