I am attempting to migrate the below table from DB2 on AIX to SQL Server:
I am using db2 export to get the data out of db2 into a comma delimited
file.
My understanding is that export will truncate the CLOB data field unless I
use the "lobsfilein" modifier.
This modifier exports the entire clob data field to its own file. I have
completed this with no issues.
So, at this point, I have columns 1& 2 in comma delim file, and column 3
in another.

I have created a comparable table on SQL server, but my dilemna is how to
get both files
inserted while maintaining data integrity.

This is a one time migration, so it doesn't have to be pretty.

Any suggestions would be much appreciated!

-kathy



CREATE TABLE "FBP"."FF_JOB_STATUS"
("JOB_NUMBER" INTEGER NOT NULL DEFAULT 0,
"STORE_NUMBER" INTEGER DEFAULT 0,
"COMMENTS" CLOB(1048576) LOGGED NOT
COMPACT
)
Kathy Lessmann
kathy.[Email address protected]
(314)444-2676

MS Sql Server LazyDBA home page