Archives of the TeradataForum

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

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

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>		<<First	<Prev	Next>	Last>>