Archives of the TeradataForum
Message Posted: Thu, 10 Jul 2008 @ 10:42:46 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|