Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  Importing Foxpro 7 data to DB2 tables

    Posted 06/08/23 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 06/08/23 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
    ------------------------------