Importing CSV, XLS and DBF files into DB2 on AIX/linux

[vin...@my-deja.com]

Hi I need to import data from CSV,XLS and DBF files onto a DB2 database
running on AIX/linux. Is there any out of the box method of doing all of
this? At minimum, i'm looking for an SQL Server-style bulk copy command line
utility that can read csv files. could you point me to the correct utility?
I have found the CPYFRMIMF CL command for db2/400 and am looking for its
equivalent on aix/linux.

Sent via Deja.com http://www.deja.com/
Before you buy.

[vin...@yahoo.com]

Hi
I need to import data from CSV,XLS and DBF files onto a DB2 database
running on AIX/linux.

At minimum, i'm looking for an SQL Server-style bulk copy command line
utility that can read
csv files. could you point me to the correct utility?
I have found the CPYFRMIMF CL command for db2/400 and am looking for its
equivalent on aix/linux.

on a slightly grandiose tone, is there already a way to import xls and
dbf files too? currently i'm thinking of converting them some way to
whatever format the bulk copy/import/data loader utility app takes, and
then loading them on to the db2 tables, but would love to have a quik
fix/off the shelf tool to do it ...
tia
vinod

[Phil Castle]

csv files can be imported into DB2 with the standard import utility:

db2 import from filename of del replace into tablename

(the "of del" says the file is of delimited format, the default delimiter
being a comma).

Needless to say, the values in your file need to be compatible with the
columns in your table.

To import xls or dbf files you will first need to get them into a comma
delimited format. There are various ways of doing this (you shouldn't need
to write any code).

Phil Castle

<vin...@yahoo.com> wrote in message news:8abh8v$sh2$1...@nnrp1.deja.com...