Importing a .dbf file into IBM DB2 table

25 pts.
Tags:
AS/400
CPYFRMIMPF
DB2
DBF file
i5
V5R4
I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I've tried using the CPYFRMIMPF command, but have had no such luck. Any help would be greatly appreciated.

Software/Hardware used:
IBM i5 model 520 running i5/OS - V5R4
ASKED: July 19, 2012  3:02 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • andyhumphreys
    By .dbf I shall assume dBase?I obviously don't know what you're dealing with but taking the CSV route and importing could end up being problematic in itself if there are complicated field structures involved. An alternative is that you could consider trying to source a JDBC driver for dBase which - if you can hack a bit of java - will enable you to write a migration routine from dBase to DB2 on the iSeries. The JDBC driver for DB2 for i is free (part of jt400Native.jar in the IBM Toolkit)
    465 pointsBadges:
    report
  • philpl1jb
    You need to go into dbase or Foxpro and export this as a csv or dif type file.  The export file will be easy to import.
    48,565 pointsBadges:
    report
  • TomLiotta
    Essentially every type of DBMS has its import/export procedure. A .CVS format is common. Most databases have ways of creating and reading .CSVs. If you wouldn't use .CSV as an intermediate format, what form would you expect to put your .dbf data into?   One alternative would be to use a process like ODBC. Determine which DBMS supplies a driver for the other platform, install the driver on that other platform, and create a process that INSERTs through the driver.   Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    ...but have had no such luck.   Why not? What happened? Error messages (message IDs)?   Are you trying to import a 'database' or are you simply copying into an existing table?   Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following