Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 23 Feb 2004 @ 14:42:44 GMT


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


Subj:   Re: How to import null values using Import Utility of SQL Assistant
 
From:   Dempsey, Mike

The full answer to this question is to use the string shown in the 'Display this string for Null data values' field on the AnswerSet tab of the options screen.

By default this will be '?' So the previous response would be correct in that case.

If your data contains <nothing> between the tabs to indicate nulls then you should set this field to an empty string. In other words simply delete whatever is in this field. (Do not enter a space character.)


Mike Dempsey
Teradata Client Tools



     
  <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