Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Jul 2004 @ 07:56:07 GMT


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


Subj:   Re: MLOAD of a file with multiple record types
 
From:   vijayaraj.shanmugam

Hi

Use NULLIF in the layout

Like this,

     .LAYOUT MIXED_FORMAT ;
     .FIELD FIELD1 * VARCHAR(100);
     .FIELD FIELD2 * VARCHAR(100) NULLIF FIELD2 = '' ;
     .FIELD FIELD3 * VARCHAR(100) NULLIF FIELD3 = '' ;
     .FIELD FIELD4 * VARCHAR(100) NULLIF FIELD4 = '' ;

And accordingly define the DML to populate you tabels.

Then in the IMPORT use the correct DML label with APPLY WHERE condition.


Hope this helps!



     
  <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