Hi everyone!

I need your help:

I have IXF files for several tables with content from a DB2 zOS V7 installation, extracted from a db2connect client.

I have an IBM DB2 UDB Version 8.1.6 ESE on my computer and need to extract only the structural information from the IXF-files (because I have to reconstruct them in an Oracle DB).

Is there any way to do that directly from the ixf-files?

I have searched the DB2 section of this forum but my keywords didn't produce a helpful result.

Thanks a lot!

Regards,

M.

P.S.: Ahem, by the way - I know that importing the ixf into my db2 installation would be an option. But I was interested in a "direct" way from the ixf to the create statement....

http://publib.boulder.ibm.com/infoce...n/r0004667.htm

Just a note on that... you can specify ROWCOUNT 1 so you don't have to load the whole thing.

My suggestion:
-------------------
db2 "IMPORT FROM myfile.ixf OF IXF ROWCOUNT 1 CREATE INTO B" >> /dev/null
db2look -d LISDEV -t B -e
db2 "DROP TABLE B" >> /dev/null
------------------

OK, it's cheating... but no table, just the DDL output... done!