Page 2 of 2
Posted: Mon Jul 23, 2012 10:45 pm
by ujala
Yes, integer values come across the ODBC interface correctly.
As mentioned earlier i am facing problem only with varchar fields.
Posted: Tue Jul 24, 2012 12:32 am
by ArndW
That is quite strange behaviour indeed. If you write to your table then capture the display the value to a file for a known string, i.e. "ABC" then do an od -x on just the first character shown, what is the value? We need to know the expected value of the first character "A" and the resulting representation in order to guess what might be happening.
Posted: Tue Jul 24, 2012 12:51 am
by venkateshrupineni
i may thought it may be the issue with Length of column or NLS try to change the length and check it once...
other try to use cast function and increase your length of your truncate clumn at the source level and passed that changed value to further stages..try this ...
Posted: Tue Jul 24, 2012 12:52 am
by ujala
sorry but i didnot get it.
Can u specify in detail
Posted: Tue Jul 24, 2012 11:20 pm
by ujala
Ran the job Changing the length and NLS and also used cast function but same result..
I am getting only the first character in the output.
Posted: Wed Jul 25, 2012 12:49 am
by ArndW
You still aren't answering the important questions. Again - what is the first character of the string supposed to be and what is the ascii code of the first character coming out.
Posted: Mon Aug 13, 2012 7:16 am
by ujala
found a work around - if i use ODBC stage instead of ODBC connector, it works fine
Posted: Mon Aug 13, 2012 7:20 am
by chulett
Then it seems to me that you should report this to your official support provider.