Archives of the TeradataForum

Message Posted: Thu, 17 Jun 2004 @ 19:33:04 GMT

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

I keep getting errors for load DATE type fields with BTEQ batch on mainframe os/390. The error msg is like:

     *** Failure 2666 Invalid date supplied for TESTLOAD.EFF_DT. when I use char(10) type.

     *** Failure 2665 Invalid date.

when I use date type.

I tried with below raw data for the date field, but none of them worked.

     2003/12/10
     04-01-2003
     2003-12-10
     04/04/2003

My entire script is like below:

     .SET QUIET OFF
     .SESSIONS 1
     .LOGON x/xxx,yyy;
     .SET FORMAT ON
     .SET SEPARATOR '|'
     DATABASE test;
     .IMPORT DATA FILE = LOADFILE;
     .REPEAT *
     USING (C1 CHAR(13), C2 CHAR(10), C3 CHAR(10), C4 CHAR(2),
            C5 CHAR(2), C6 CHAR(1),C7 DATE, C8 DATE)
     INSERT INTO TESTLOAD
     VALUES (:C1, :C2, :C3, :C4, :C5, :C6, :C7, :C8);
     .LOGOFF;
     .QUIT;

Can you take a look and get me some advice please? Thanks very much.

zqi

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