Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 22 Nov 2002 @ 00:31:33 GMT


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


Subj:   Re: Continuations in FastLoad
 
From:   Dwight Etheridge

wgr,

You might defer the null check until values() clause. Since you appear to be an all or nothing check for low values, you may be able to use TRIM.

,case when TRIM ( TRAILING '00'XCF FROM :IN_STR_ADR_LN_1 )=' '
then null
else :IN_STR_ADR_LN_1 End

I also have some SyncSort code around somewhere that can convert the low values to spaces before loading, if you want that.

Hope this may spark some ideas.



     
  <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: 23 Jun 2019