Archives of the TeradataForum

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

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

Howard:

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||'
     '||hr||':'||min||':'||sec;

     .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,

Mike

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