Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 14 Nov 2002 @ 08:54:28 GMT


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


Subj:   Re: INDICATORS FIELD in FastLoad Script
 
From:   David Wellman

Reddy,

What tool are you using to issue the SELECT * ? And how does that tool display NULLs?

If you're using Queryman then it's default character for NULLs is '?'.

To verify that you've realy got NULLs loaded, try the following query (from any tool)

sel *
from xxx
where phoneno is null;

From what you've said you should get one row back.


Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)



     
  <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: 28 Jun 2020