Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 20 Aug 2006 @ 10:34:47 GMT


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


Subj:   Re: Teradata trailing spaces truncation in strings
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, August 18, 2006 15:42 -->

  I am observing trailing spaces truncation when converting data from oracle to teradata using utilities .  


I believe Teradata truncates trailing spaces when you send data as CHAR but not VARCHAR. This is my understanding on how it works. So, you might need to check how your load utility sending data. Below is an example.


:-)


     --------------------------------------------------------------

     show table test;

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

     ---------------------------------------------------------------
     CREATE SET TABLE test ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           ch VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC)
     PRIMARY INDEX ( ch );


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     delete test;

     delete test;

      *** Delete completed. No rows removed.
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     ins test(cast('abcd   ' as char(10)));

     ins test(cast('abcd   ' as char(10)));

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


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     sel '-'||ch||'-' from test;

     sel '-'||ch||'-' from test;

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     (('-'||ch)||'-')
     ----------------
     -abcd-

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     delete test;

     delete test;

      *** Delete completed. One row removed.
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     ins test(cast('abcd   ' as varchar(10)));

     ins test(cast('abcd   ' as varchar(10)));

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


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     sel '-'||ch||'-' from test;

     sel '-'||ch||'-' from test;

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     (('-'||ch)||'-')
     ----------------
     -abcd   -

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


     
  <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: 15 Jun 2023