Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 May 2003 @ 20:08:11 GMT


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


Subj:   Re: Multi load -- Data file with spaces
 
From:   Adriano Ferreira

I think you can do it by declaring fields in the layout that don't get used in DML statements. Just like this that declares IN_EOL to mark the position of the new line character.

.LAYOUT INPUTLAYOUT;
      .FIELD IN_num_invoice                              * CHAR( 14);
      .FIELD IN_Id_Day                                  * CHAR( 8);
      .FIELD IN_EOL             * CHAR( 1);

The DML only uses :IN_num_invoice and :IN_Id_Day.

If you had one space between the num_invoice and id_day fields, I think you could use

.LAYOUT INPUTLAYOUT;
      .FIELD IN_num_invoice                              * CHAR( 14);
      .FIELD IN_SEP1                              * CHAR( 1);
      .FIELD IN_Id_Day                                  * CHAR( 8);
      .FIELD IN_EOL             * CHAR( 1);

Regards,

Adriano.



     
  <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