Hi,
Teradata 13.0 when using ANSI teradata mode data conversion decimal to varchar of same length getting blank as output.
sel 0 (decimal(3,0))(varchar(3))
0
--------
 
But using ansi mode conversion format getting expected value as 0.

Hey all, love this forum, it's helped me so much.  Using Mac, one of very few using studio (others are using SQL assistant) so I'm kind of pioneering on my own as an early adopter.  I saw another thread where someone realized ANSI was causing their code to be case sensitive, but I really didn't understand the answer.

I am working on an application that takes records from Hadoop and inserts them into Teradata via sqoop(JDBC).
I am using TERA mode for the connection and the target table is SET table. I am getting duplicate row issue for some datasets.