Archives of the TeradataForum
Message Posted: Mon, 28 Aug 2000 @ 15:36:27 GMT
I need some help using MultiLoad to update or insert a record that includes a data field. MultiLoad is generating an ET error record for each of mine, and the date field is always getting the error 2666 - Invalid date supplied.
My Multiload statements follow.
.BEGIN IMPORT MLOAD TABLES Junk; .LAYOUT MYJUNK; .FIELD IJUNK01 * CHAR (15); .FIELD IJUNK02 * DATE ; .DML LABEL MYUPSERT DO INSERT FOR MISSING UPDATE ROWS; UPDATE JUNK SET JUNK02 = :IJUNK02 (FORMAT 'MMDDYYYY') WHERE JUNK01 = :IJUNK01; INSERT INTO JUNK (JUNK01, JUNK02) VALUES (:IJUNK01, :IJUNK02 (FORMAT 'MMDDYYYY')); .IMPORT INFILE DDIN LAYOUT MYJUNK APPLY MYUPSERT; .END MLOAD;
My target table is named Junk, with these fields:
JUNK01 CHAR(15), JUNK02 DATE FORMAT 'MMDDYYYY'
The data I'm loading looks like this:
----+----0----+----2--- 111 08272000 222 08272000 555 08282000
I tried a host of modifications to the table and the statements and the data, with no success.
An entry in NCR Support Link on the Problem "How to format the date for MultiLoad" gives the Solution as: "The date needs to be the same as specified in the column of the table or be the same as the overriding format, if it is present in the Insert Statement."
I would be most grateful for any help.
Multiload "echoes" MLoad 07.02.00; we have Teradata V2 R.02.01.02.
Mary Lou Arundell
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|