Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Change in Behavior of the Query
 
From:   Kondalrao_Munagala

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016