Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 14 Aug 2006 @ 09:29:39 GMT


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


Subj:   Re: Alternative to Insert/Select
 
From:   Geoffrey Rommel

  ... I had thought I might be able to accomplish this with Multiload or TPUMP with an INMOD exit routine. However when I read the MLOAD documentation it doesn't look like I can transform the SALE_DATE column as I need to, to get the data into the warehouse table in the format I need.  


I'm not quite following you here, Anomy. In an INMOD, you can do any kind of transformation you want.

You didn't say whether the source data is coming from a mainframe or Unix, but since it is a "legacy" system I'll assume it's a mainframe. In the INMOD, you can have two tables in working-storage for Julian days (one for common years, one for leap years). Then add '20' to the front, etc., to change the Julian day to whatever format you like, say 'yyyy-mm-dd', and return the record to MultiLoad. In your .DEFINE and .FIELD statements you describe the record as it comes back from the INMOD, not the original record. You can then say (syntax may not be quite right here):

     .field  * mo_better_date  char(10);

and insert as usual. MultiLoad will convert the character field to a real date.

Examples are available in the manual, in the SAMPLIB PDS distributed with TDP (or, in Unix, under /usr/sample), and here:

www.teradataforum.com/l030315a.htm



     
  <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