Archives of the TeradataForum

Message Posted: Tue, 06 Sep 2005 @ 16:40:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi all,

We have two mainframe partitions say X and Y. Jobs are submitted through both of these partitions on a common teradata box.

I executed the below given query on both the machines using a BTEQ. On the machine X, the query runs absolutely fine and the table is getting populated with data.

But on Y it abends giving the following error message 'Right truncation of string data'.

     SELECT A.SVCID, B.* FROM A
     INNER JOIN B
     On CAST(A.SVCID AS CHAR(10) ) = CAST(B.SID as CHAR(10));

In table A, SVCID is a DECIMAL(18,0) and B.SID is VARCHAR(20).

Can you please tell me why this query is behaving differently on two different partitions although the back-end database is same?.

Regards

Kondal

	<Prev	Next>		<<First	<Prev	Next>	Last>>