*** Failure 6760 Invalid timestamp. in bteq import

Teradata Applications
n_1
N/A

*** Failure 6760 Invalid timestamp. in bteq import

Hi All,

While importing data from INDICDATA file I m getting following error :

 *** Growing Buffer to 4757

 *** Failure 6760 Invalid timestamp.

                Statement# 1, Info =0

 

Export Script :

 

.EXPORT INDICDATA FILE='data.txt'

.decimaldigits 38

.SET WIDTH 9000

.SET SESSION CHARSET "UTF8"

SELECT CAST(Col1 AS CHAR(20)),

CAST(Col2 AS CHAR(20)),

CAST(Col3 AS CHAR(4)),

CAST(Col4 AS CHAR(100)),

CAST(Col5 AS CHAR(100)),

CAST(Col6 AS CHAR(150)),

CAST(Col7 AS CHAR(19)),

CAST(Col8 AS CHAR(100)),

CAST(Col9 AS CHAR(19)),

CAST(Col10 AS CHAR(100)),

CAST(Col11 AS DECIMAL(38,0)),

CAST(coalesce(Col12,CAST('2014-01-01 00:00:00' AS TIMESTAMP(0))) AS CHAR(19)),

CAST(Col13 AS CHAR(1000)),

CAST(Col14 AS INTEGER),

CAST(Col15 AS INTEGER),

CAST(Col16 AS CHAR(1)),

CAST(Col17 AS CHAR(19)),

CAST(Col18 AS CHAR(19))

FROM status;

.LOGOFF

 

.QUIT

=========****==============

Table Structure :

CREATE MULTISET TABLE Rc_Test ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      Col1 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC  NOT NULL,

      Col2 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC  NOT NULL,

      Col3 CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC  NOT NULL,

      Col4 VARCHAR(100) CHARACTER SET UNICODE NOT CASESPECIFIC  NOT NULL,

      Col5 VARCHAR(100) CHARACTER SET UNICODE NOT CASESPECIFIC  NOT NULL,

      Col6 VARCHAR(150) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL,

      Col7 TIMESTAMP(0) ,

      Col8 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC  NOT NULL,

      Col9 TIMESTAMP(0) ,

      Col10 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC  NOT NULL,

      Col11 DECIMAL(38,0)  NOT NULL,

      Col12 TIMESTAMP(0),

      Col13 VARCHAR(1000) CHARACTER SET UNICODE NOT CASESPECIFIC ,

      Col14 INTEGER   NOT NULL,

      Col15 INTEGER NOT NULL,

      Col16 CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC  NOT NULL,

      Col17 TIMESTAMP(0)  NOT NULL,

      Col18 TIMESTAMP(0) )

PRIMARY INDEX XNUPI_RC_STATUS ( Col1 ,Col2 ,

Col23 );

=========****==============

Import Script :

========

.IMPORT INDICDATA FILE='data.txt'

.decimaldigits 38

.SET SESSION CHARSET "UTF8"

.REPEAT *

USING Col1 (CHAR(20)),

Col2 (CHAR(20)),

Col3 (CHAR(4)),

Col4 (CHAR(100)),

Col5 (CHAR(100)),

Col6 (CHAR(150)),

Col7 (CHAR(19)),

Col8 (CHAR(100)),

Col9 (CHAR(19)),

Col10 (CHAR(100)),

Col11 (DECIMAL(38,0)),

Col12 (CHAR(19)),

Col13 (CHAR(1000)),

Col14 (INTEGER),

Col15 (INTEGER),

Col16 (CHAR(1)),

Col17 (CHAR(19)),

Col18 (CHAR(19))

INSERT INTO status_test

VALUES (TRIM(:Col1),

TRIM(:Col2),

TRIM(:Col3),

TRIM(:Col4),

TRIM(:Col5),

TRIM(:Col6),

CAST(:Col7 AS TIMESTAMP(0)),

TRIM(:Col8),

CAST(:Col9 AS TIMESTAMP(0)),

TRIM(:Col10),

:Col11,

CAST(:Col12 AS TIMESTAMP(0)),

TRIM(:Col13),

:Col14,

:Col15,

TRIM(:Col16),

CAST(:Col17 AS TIMESTAMP(0)),

CAST(:Col18 AS TIMESTAMP(0)));

.LOGOFF

.QUIT

Could anyone please help me with this.

Thanks