Archives of the TeradataForum
Message Posted: Tue, 06 Sep 2005 @ 16:40:00 GMT
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?.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|