Toad World® Forums

Problem migrating tables


#1

Hello.

I have been trying to move tables under a certain schema to another database under the same schema. When I run this with Toad 4.6.2 some of the table loads give me messages like the one below. When I run it with Quest Central for DB2 it works fine so I am guessing there must be some sort of global parameter I am missing. Anybody run into something like this before?

Category Timestamp Duration Message Line Position
Error 8/26/2010 1:08:33 PM 0:00:00.000 SQL3150N The H record in the PC/IXF file has product “DB2 02.00”, date
“20100826”, and time “124256”.

SQL3153N The T record in the PC/IXF file has name “C:\Documents and
Settings\jim.rutten\Application Data\Qu”, qualifier “”, and source "
".

SQL3109N The utility is beginning to load data from file
“ETL_IMAGEBACKGROUNDCOLOR1691102759.ixf”.

SQL3168W The PC/IXF column specified to be loaded into database column
“IMAGETYPEID” is not compatible with the database column. Nulls will be
inserted.

SQL3166W No PC/IXF column was specified to be loaded into database column
“ORIGIMAGEFILEREF” or the specified PC/IXF column does not exist. Nulls will
be inserted.

SQL3166W No PC/IXF column was specified to be loaded into database column
“WEBCONVERTEDFILEREF” or the specified PC/IXF column does not exist. Nulls
will be inserted.

SQL3166W No PC/IXF column was specified to be loaded into database column
“ECOMMERCEUSERID” or the specified PC/IXF column does not exist. Nulls will
be inserted.

SQL3166W No PC/IXF column was specified to be loaded into database column
“CLIENTID” or the specified PC/IXF column does not exist. Nulls will be
inserted.

SQL3166W No PC/IXF column was specified to be loaded into database column
“IDPROFILE” or the specified PC/IXF column does not exist. Nulls will be
inserted.

SQL3166W No PC/IXF column was specified to be loaded into database column
“ONECOLORIDPROFILE” or the specified PC/IXF column does not exist. Nulls will
be inserted.

SQL3166W No PC/IXF column was specified to be loaded into database column
“IMAGESTATUS” or the specified PC/IXF column does not exist. Nulls will be
inserted.

SQL3166W No PC/IXF column was specified to be loaded into database column
“HIDEIMAGEDISPLAYIND” or the specified PC/IXF column does not exist. Nulls
will be inserted.

SQL3166W No PC/IXF column was specified to be loaded into database column
“PARENTIMAGEID” or the specified PC/IXF column does not exist. Nulls will be
inserted.

SQL3166W No PC/IXF column was specified to be loaded into database column
“NUMBEROFCOLORS” or the specified PC/IXF column does not exist. Nulls will be
inserted.

SQL3086N There was no source column specified to be loaded into database
column “BKGRDTRANSPARENTIND” or the specified source column does not exist,
but the database column is not nullable.

SQL3110N The utility has completed processing. “0” rows were read from the
input file. 4824 0