Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 27 Dec 2002 @ 05:03:23 GMT


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


Subj:   Re: TIMESTAMP in Teradata
 
From:   Sanjaya Nagabhushan

The error "Right truncation of string data" manifests only in ANSI mode despite providing sufficient space [char(26)]. No complaints in TERADATA mode. Use this approach instead ...

show table a;

 *** Text of DDL statement returned.
 *** Total elapsed time was 1 second.

------------------------------------------------------------------------
CREATE SET TABLE TMP.a ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT
     (
      i INTEGER,
      d CHAR(26) CHARACTER SET LATIN CASESPECIFIC)
PRIMARY INDEX ( i );

 BTEQ -- Enter your DBC/SQL request or BTEQ command:

ins into a (3, substring(cast(current_timestamp as char(32)) from 1 for 26));

ins into a (3, substring(cast(current_timestamp as char(32)) from 1 for 26));

 *** Insert completed. One row added.
 *** Total elapsed time was 1 second.

 BTEQ -- Enter your DBC/SQL request or BTEQ command:

Sanjay



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020