MetaData mismatch

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
MURALI123
Participant
Posts: 46
Joined: Sun Jun 21, 2009 1:37 am
Location: CHENNAI

MetaData mismatch

Post by MURALI123 »

Hi all,
can any body help me about the below warning
i used to load the data from db2 to SqlServer here the records are loded into successfully but warning is generated
please find the below warning log can any body give suggestion
Here i use the db2 column type is BigInt(19) and target sql server type is Integer(30) but the below warning is generated can any one give idea how to slove this?

DSD.BCIOpenW results of SQLColAttributes(ColumnName) gave MetaData mismatch
COLUMN.TYPE Expected = Integer Actual = Numeric

Thanks,
Malli
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Try changing your metadata to what it found it to be.
-craig

"You can never have too many knives" -- Logan Nine Fingers
MURALI123
Participant
Posts: 46
Joined: Sun Jun 21, 2009 1:37 am
Location: CHENNAI

MetaData mismatch

Post by MURALI123 »

Hi,
Is there problem with target db datatype.
thanks,
Malli
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Seems to be. Try.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply