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


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