[dba-SQLServer] DB2 anyone?

Hi Arthur:

I finally got a reply from a friend who was trained in DB2. Her best
suggestion was to import the data into another SQL DB like MS SQL and then
export in a fashion the DB2 could import. Her other suggestion was to import
the data into MS SQL and link the 2 databases and build the tables from
there. 

Sorry to not be more helpful but DB2 seems to regards other DBs like MS
regards Linux.

Jim  

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Monday, October 29, 2007 7:03 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] DB2 anyone?

Anybody on this list familiar with DB2? I installed DB2 Express. I want to
import a database from a bunch of text files. There are some files that
purport to help me do this, with weird extensions like .zpl or something. I
also have the database installed in SQL Server, Oracle and MySQL, so perhaps
I could import it from there. I looked at one DB2 utility but it seemed to
want comma-delimited files and the text files I have are fixed-width.

TIA,
Arthur
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com