Issue during Conversion of varchar to Timestamp(0)

UDA

Issue during Conversion of varchar to Timestamp(0)

Hi,

I am using TPT to load my table.

I am facing an error in converting varchar to TimeStamp(0).

The segment code which is giving the error is :

STEP LOAD_DATA_INTO_TABLE

(

   APPLY ('INSERT INTO '||@TargetTable||'(

          :IDNT_TICK,

    :MSG_ID,

    :MSG_ID2,

    :MSG_ID_SERV,

    :SPLIT_ROW_NUM,

    :COMP_REIN_NUMR_FACT,

    :NUMR_FACT

);')

   TO OPERATOR (LOAD_OPERATOR [1])

   SELECT * FROM OPERATOR ( FILE_READER [1] );

);

);

IDNT_TICK is the column of data type Timestamp(0) which is defined as varchar(14) in the TPT.

Kindly let me know if there are any fixes.

Regards,

Krishna

3 REPLIES
Enthusiast

Re: Issue during Conversion of varchar to Timestamp(0)

can you please post sample data
Teradata Employee

Re: Issue during Conversion of varchar to Timestamp(0)

Sample data would help .... but it seems to be a FORMAT issue.

Enthusiast

Re: Issue during Conversion of varchar to Timestamp(0)

The timestamp(0) is expected to have length 20 by teradata. Hence the issue must be with source data or the defintion that has got length of 14 resulting in truncation.