Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 26 Feb 2003 @ 22:50:33 GMT


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


Subj:   Re: Searching for unprintable characters
 
From:   McCall, Glenn D

Try this

Select the_problem_column, and_other_fields_of_interest
From the_problem_table
Where char2hexint(the_problem_column) = '0000';

Obviously substitute my silly table/column names for your table and column names.

You should also be able to use the where clause in a delete or an update if need be. You can also use char2hexint in the select to see what is in there (you don't need to fexp to MVS).

Eg:

Select the_problem_column, char2hexint(the_problem_column)
From the_problem_table


Hope this helps

Glenn Mc



     
  <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