Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Importing Foxpro 7 data to DB2 tables

    Posted Thu June 08, 2023 11:10 AM

    Is there anyone out there with experience moving Foxpro .dbf data to DB2? I know there are a few ways I can accomplish this, but am looking for advice on what might be the easiest and fastest. It's been a few years since I've done this, so I'd like to know if there is a process I haven't considered. Thanks!



    ------------------------------
    Lori Austin
    Senior Systems Analyst
    NALC
    Washington DC
    ------------------------------


  • 2.  RE: Importing Foxpro 7 data to DB2 tables

    Posted Thu June 08, 2023 01:06 PM

    1. Check structure of x.dbf for data types compatibility with Db2 data types;
    2. Export data to CSV
    3. Create Db2 table based on 1. above
    4. Import data from 2. above

    Things to look at:
    - code page differences
    - delimiter character in data stream



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message