Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 31 Oct 2005 @ 17:54:31 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Fastexport, multiload, nulls and blanks
From:   Simon Bloomer

Hi all

I have a question relating to fastexport and null handling.

We have a series of fastexports which we use to export data which is then mloaded into the EDW targets.

Many of the columns have nulls. The problem I am having is that these nulls are not being correctly loaded into the targets and are loaded as blanks. I would have assumed that using the fastload format that these nulls would have been correctly handled. However, using case in the mload doesn't want to work correctly either

If I try

     .FIELD  SerialNumber    * char(10)

     case when :serialnumber  = '' then null else :serialnumber end

blanks are inserted

     case when :serialnumber  = '          ' then null else :serialnumber end
     (note 10 spaces between quotes)

also results in blanks

I suppose I could do a case statement in the original exports and use that value for the multiload case, but that seems to be a bit self defeating.

Am I missing something?



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023