Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 28 Aug 2000 @ 21:09:37 GMT

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

Subj:   Re: MultiLoad Date Fields
From:   Mary Lou Arundell

The (date, Format'YYYYMMDD') did it.

Eric: In response to your question, "In order for the original suggestions to work the file must contain a char(8) data value for the date. Does it?" Yes, it did/does.

Fred: In response to your "IF...", "If the input data matches the FORMAT used in CREATE TABLE". I created and recreated the table with and without a format statement on Junk02. With the format, I tried both "yyyymmdd" and "mmddyyyy", and subsequently matched the input data to the format specified, as well as the format statement in the MLoad DML. It was never enough.

Thanks Barry, Gloria, Fred, Eric, and Roland for your help with this problem.

Mary Lou

  <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