Page 1 of 1

Warnings in ODBC Connector Stage when Table Action = APPEND

Posted: Tue Feb 16, 2010 4:45 pm
by Ankur_KapoorUK
Hi ,

In a jon I am try to populate Oracle table BY a source dataset with RCP Enabled.

In ODBC Connector Stage , Table Action = CREATE OR REPLACE then no warning is coming up.

bUT Table Action = APPEND then the mentioned warning is coming up :p-

TgtCDLTblODBC: The length of VARCHAR column STAT cannot be validated because the database column is WVARCHAR and character set conversion is involved. Inadequate column lengths can lead to data truncation or unexpected errors.

Please note source STAT Column is of Varchar type.


Kindly provide the inputs regarding it

Posted: Wed Feb 17, 2010 4:40 am
by Sreenivasulu
Instead of 'typing' the error mesage kindly can you cut an paste the appropriate error message .



Regards
Sreeni

Re: Warnings in ODBC Connector Stage when Table Action = APP

Posted: Mon Jul 26, 2010 4:09 am
by kamesh_sk
HI,

Did you find a solution to this problem.IAm also facing an similar problem with my jobs.
Can you kinldy post your observations.

Thanks
Kamesh

Posted: Mon Jul 26, 2010 5:03 am
by kumar_s
Is that column length more than 255?
When you let to Create or Replace, what is the data type of the filed in the target table?