Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2007
    Posts
    3

    Unanswered: Conversion of ISAM format data files into Oracle compatible format

    Hi,

    I have certain .dat files created in an EMR (electronic medical record) software called Pratice Partners. They are in the C Tree binary format. Now I have to convert this data so that I can enter this data into the Oracle database.

    Can someone tell me how I can convert the ISAM data in the .dat files to a format I can use in Oracle?

    Thanks!!!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You need to use (or write) a utility on the IBM to create a "flat file" in text format. Keep in mind you'll likely need to do EBCDIC to ASCII conversion;
    unless the mainframe can directly produce ASCII files.
    It has been more than 3 decades since I did anything with ISAM files & I don't recall a whole lot of details.

    What is target OS name & version?
    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.

  3. #3
    Join Date
    Oct 2007
    Posts
    3
    Thanks for your reply. Do you think you could probably send me a few links, if you can, which shows how to write the utilty to create flat files?

    The OS is Windows Server 2003.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Is GOOGLE broken for you?
    Results 1 - 10 of about 5,360 for isam to ascii conversion.
    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.

  5. #5
    Join Date
    Oct 2007
    Posts
    3
    That was not my question! If i had to google it, I wouldn't be wasting my time reading posts from you, now would I?

    Anyway, thanks!!

  6. #6
    Join Date
    Oct 2007
    Posts
    6
    I have used a couple of the data tools from Pervasive (http://pervasivedatatools.com) to parse ISAM files. The Data Parser for C-ISAM and the Data Parser for Binary worked well for me. Each lets you export the data to a CSV text format. You can then use their Data UpLoader to Oracle Database to map the CSV data into Oracle. Hope this helps!

Posting Permissions

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