Moving data from .DBF file to DB2/2

Joost Vocke

unread,

Dec 3, 1996, 3:00:00 AM12/3/96

to

How do i move data from an indexed dBASE .DBF file to a new database
created in DB2/2?
Is there a utility for this or are there procedures?

Thanks, Joost Vocke

bha...@vnet.ibm.com

unread,

Dec 4, 1996, 3:00:00 AM12/4/96

to

Joost Vocke wrote:
>
> How do i move data from an indexed dBASE .DBF file to a new database
> created in DB2/2?
> Is there a utility for this or are there procedures?

I believe the .dbf file is a delimited ASCII file? If so, then
you can use this file in the DB2/2 LOAD or IMPORT commands
to load the data into a predefined table.

=======================================================
Bob Harbus - DB2 Technical Support/Consulting - Toronto
Supporting DB2 Universal Database
Internet: bha...@vnet.ibm.com

Kevin Hunt

unread,

Dec 4, 1996, 3:00:00 AM12/4/96

to

rha...@torolab.ibm.com wrote:
>
> Joost Vocke wrote:
> >
> > How do i move data from an indexed dBASE .DBF file to a new database
> > created in DB2/2?
> > Is there a utility for this or are there procedures?
>
> I believe the .dbf file is a delimited ASCII file? If so, then
> you can use this file in the DB2/2 LOAD or IMPORT commands
> to load the data into a predefined table.

I believe that .DBF file are not delmited ASCII. I used Lotus to export
the .DBF into a comma delimited ASCII file (could export to many
different formats but need ASCII delimitd or Fixed for DB2 Common
Server). Just transfer this file over to your server then you can use
LOAD to get it into the table.

Good luck!

Kevin Hunt
Sr. DBA
kh...@hollister.com

D Preble

unread,

Dec 4, 1996, 3:00:00 AM12/4/96

to

rha...@torolab.ibm.com wrote:
>
> Joost Vocke wrote:
> >
> > How do i move data from an indexed dBASE .DBF file to a new database
> > created in DB2/2?
> > Is there a utility for this or are there procedures?
>
> I believe the .dbf file is a delimited ASCII file? If so, then
> you can use this file in the DB2/2 LOAD or IMPORT commands
> to load the data into a predefined table.
>

> =======================================================
> Bob Harbus - DB2 Technical Support/Consulting - Toronto
> Supporting DB2 Universal Database
> Internet: bha...@vnet.ibm.com

*.dbf file is NOT comma delimited, however you can read this with many
things (dbase, Access for example) and do a export to create a comma
delimited file. Then use a DB2 load.

bha...@vnet.ibm.com

unread,

Dec 5, 1996, 3:00:00 AM12/5/96

to

Thanks to all for correcting me.

lleb...@ge.hydro.qc.ca

unread,

Dec 19, 1996, 3:00:00 AM12/19/96

to

After migrating a database from DB2/2 1.x to 2.1.1, remote command line SQL
statements (other than the initial connect) return a SQS0805N message stating
that NULLID.SQL... mode is missing. The problem seems to cure itself after some
time (overnight). Is there a bind we must do following migration to prevent this
right away ?

Leon Katsnelson

unread,

Dec 21, 1996, 3:00:00 AM12/21/96

to

SQL0805 means that you forgot to bind the applciation (eg. Command Line
Processor).

Steve Behman

unread,

Dec 22, 1996, 3:00:00 AM12/22/96

to Leon Katsnelson

Sorry I did not see the original, but I had the SAME problem.

There is a "response file" for Binding the changed .bnd's for the
update.
On some systems (at least mine and the original questioner's) the ORDER
of the list of files to be bound IS ORDER SENSITIVE!

In the end and with the help of DB2/2 support I got the required files
all bound. I built a rexx exec with a nested loop (outer loop on the
Database names, inner loop on the list of bind files) which bound each
of the files listed in the response file to each of my databases -- ONE
AT A TIME. This procedure worked and I had no further problems.

Steve Behman
<sbe...@ibm.net>

P.S. Neither the support rep nor I knew why it worked and the "list
approach" did not -- I just HATE mysteries like that!