The TeradataForum depends on cookies for its operation. Please refer to our Privacy page for details. By closing this banner or continuing to browse the TeradataForum website, you agree to the use of cookies.

 
Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   ERROR on load DATE field with BTEQ
 
From:   zqi

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 31 Dec 2015