hi,

When a table with unique key constraint is imported,unique key constraint is missing in the re created table.

As its a limitation of IMPORT utility,unique key constraints are ignored while importing a table.

Reference:
IBM DB2 9.7 for Linux, UNIX and Windows Information Center

Because of application requirement we cannot go for primary key instead of unique key(),do we have any other alternative methods to retain unique key constraint while importing the table?

Thanks in advance

is it with import and create_into or ??
if the table existed before, take a db2look before dropping the table and after import recreate the constraint..

Thanks for reply..

We are using import utility as follows:

IMPORT FROM EMPLOYEE.SQL OF IXF CREATE INTO ORG.EMPLOYEE

Since in our case exporting and importing instances will be different, db2look will not be helpful.

Do we have other alternatives?

"Since in our case exporting and importing instances will be different, db2look will not be helpful."
db2look output is an sql flat file : you can specifiy -t and generate only info for this table
it can be used in any instance
you can even use awk to cut specific statements...