Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Import from DBF to DB2

0 views
Skip to first unread message

@srv.pl Jaros³aw Tabor

unread,
Nov 14, 2001, 2:37:26 PM11/14/01
to
Hello!

I have many DBF files, which I need to transfer to DB2. Is there any
automatic tool to covert them ? I'm using now perl scripts and load
utility, but it takes a lot of time to prepare scripts for every file. I
looking for something faster and simpler.

JT.

Knut Stolze

unread,
Nov 14, 2001, 5:20:24 PM11/14/01
to

As far as I know, there is no built-in support for DBF in db2. (I guess one
reason is the multitude of different dbf formats; but that is speculation on
my side.)

If you don't find a tool for it, I would suggest to implement your own
import routine. This are about 1000 lines of (C-)code you would need. It
is actually quite straight forward.

--
Knut Stolze
DB2 UDB Spatial Extender
IBM Silicon Valley Lab

Dmitry

unread,
Nov 15, 2001, 4:20:06 AM11/15/01
to
Hello,

You can use 3d party migration tool Chyfo (www.ispirer.com/products)
This is a command prompt tool (less 100k size) that can export DBF files to
flat files, generate native DDL statements like CREATE TABLE, CREATE INDEX
for IDB DB2 and scripts for IBM DB2 IMPORT/LOAD commands.
It's easy to use. For example, the command:
chyfopro.exe /d=dbf_db /t=* /target=db2
will export all tables from DBF database.

Best regards, Dmitry

"Jarosław Tabor" <jarek @ srv. pl> wrote in message
news:9suh7d$i51$2...@pingwin.acn.pl...

0 new messages