Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    5

    Unanswered: Extract table structure from ixf file

    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....
    Last edited by magro; 02-23-06 at 08:27.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

  3. #3
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by magro
    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....
    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!
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •