Archives of the TeradataForum

Message Posted: Mon, 28 Aug 2000 @ 15:36:27 GMT

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

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
Database Systems Analyst
University of Cincinnati

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