Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004

    Question Unanswered: Help with .ixf files

    Hello -

    I am new to this forum, so I hope I'm in the right spot, or if someone can point me to the forum I should try - I would greatly appreciate it. (I've also posted this same question in the DB2 forum...)

    I hope someone can help me, as I'm running out of time for this project...
    I am being supplied a .ixf file from an agency, and I need to bring this file into a format that can be imported into an Oracle 9i database. It can be converted to a .csv file, or other format that Oracle can import. Has anyone come across any method that has been done to do this??

    Thanks much in advance

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    What is an '.ixf' file? Where does it come from? What application creates it?
    If you can convert it to a '.csv' file then you can load it into an oracle table using the SQL*Loader utility.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Nov 2004
    I apologize... I first posted the question in the db2 area, so I wasn't thinking to elaborate on what a .ixf file is...

    a .ixf file is a file that is exported from a db2 database. Unfortunately, the only thing I know is that it is a pc version of db2 - I'm assuming the latest. The file comes from another agency and unfortunately, they are not able to update their process at this time.. and, unfortunately, this is the problem I'm having... converting it to a .csv file or any that Oracle can read.

  4. #4
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    1) Install DB2
    2) Import the *ixf file into DB2
    3) Write a small PERL program to read the DB table(s) & insert into Oracle.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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