Home Page for the TeradataForum

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


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.



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