Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 28 Aug 2000 @ 16:20:14 GMT

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

Subj:   Re: MultiLoad Date Fields
From:   Barry Hull

Mary Lou,

Change the "FIELD" command in the "LAYOUT" section to define IJUNK02 as "CHAR(8)". The Multiload will then use the format that you specified to convert it to a date (as long as it's defined as a DATE column in the table). If you have trouble with it, you may have to put parenthesis around the entire expression like this:

(:IJUNK02 (format 'MMDDYYYY'))



  <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