Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Nov 2004 @ 21:54:35 GMT


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


Subj:   Re: Fast Export Decimal problem
 
From:   Lunn, Jonathan

Fachtna,

Try using a case statement to transform the nulls to another value - sorry, I'm not familiar enough with DB2 to know what it's looking for, but you likely know what you need. If you can read the file and work on it in DB2, then change a null to the word 'NULL', or '?'. If you need to keep the value strictly numeric for an MVS load, I believe '00'xb is the equivalent of low-values.


Hope this helps.

Jonathan



     
  <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