Archives of the TeradataForum

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

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

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>>