Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 10 Jul 2008 @ 10:42:46 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Queryman Import Bug
From:   Weng, Ray

I'm trying to import a text file into teradata via queryman. The file only includes one string column. And the result shows that the teradata trimmed the first and the last characters of the string when it is over 18 chars long. In the table, I define it as varchar(100) and it is a volatile table.

I believe it has nothing to do with the volatile?

We can try a lab like this:

     Create volatile table vt_ms_mntn_cust
     (cust_id varchar(100))
     on commit preserve rows;

     insert into vt_ms_mntn_cust (cust_id) values (?);

Anyone please let me know if you are able to import the value "aa1630511051793436630" correctly into the table.

Ray Weng

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