Archives of the TeradataForum

Message Posted: Wed, 20 Dec 2006 @ 10:26:14 GMT

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

Hi all,

I met a weird issue when I was trying to use the import data feature in Queryman. What I did is that I created a table with only one column of decimal(18,0) firstly. And then I tried to insert my data into the table, the query is:

     insert into ct_prod (id)
     values ( ? );

Here is a piece of my data file:

     115814480
     115810540
     115811260
     115813230
     115807100

And I found the first digit and the last digit of the number inserted has gone! So what in the table is:

     1581448
     1581054
     1581126
     1581323
     1580710

Could anyone help to see how it happened?

Regards,

Silei

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