Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Nov 2003 @ 22:08:15 GMT


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


Subj:   Re: Error message in fast export
 
From:   Meade, Cornelius

This is something I ran into not too long ago. I don't know if your particular occurrence could be related to something in V2R5 or upgrading but I can say I've seen this error in earlier versions as well....The following may be useful to you in identifying the rows in your table that are the root cause of the problem. It is tedious detective work if your table has loads of columns but you can automate the process with a little work.

Step 1.
SELECT count(column_name) FROM table_name WHERE Translate_Chk(column_name using Latin_To_Unicode) <> 0 ;

Step 2. (perform if non-zero count value returned from Step 1. query)
SELECT column_name FROM table_name WHERE Translate_Chk(column_name using Latin_To_Unicode) <> 0 ;


     
  <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: 15 Jun 2023