Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 10 Oct 2000 @ 16:43:31 GMT

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

Subj:   Re: TIMESTAMP and Multiloads
From:   Michael Larkins


There is something you can try, I have not used it for this purpose, but it might just work. MultiLoad has the ability to concatenate fillers and fields into a new field. Like the following: (note the email has wrapped the line)

     .layout mylayout;
     .filler dy            *   char(2);
     .filler omitdash1     *   char(1);
     .filler mth           *   char(2);
     .filler omitdash2     *   char(1);
     .filler yr            *   char(4);
     .filler omitdash3     *   char(1);
     .filler hr            *   char(2);
     .filler omitdot1      *   char(1)
     .filler min           *   char(2);
     .filler omitdot2      *   char(1)
     .filler sec           *   char(9);
     .field  wholetmsp     *   yr||'-'||mth||'-'||dy||'

     .dml label mylabel;
     insert into table  values (wholetmsp);

Until there is a (timestamp, format ' ') capability, I think using the above might be your only option. The names for the fillers is optional, I used them to describe their intent.

Good luck,


  <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: 27 Dec 2016