All Forums Database
richa.prvr 9 posts Joined 09/12
04 Jun 2014
Failure 2673 The source parcel length does not match data that was defined.

Hello,
I created a flat file and now need to load that data to teradata table. But while importing the script was facing "Failure 2673 The source parcel length does not match data that was defined error"
My data in the file :

rahul 100

richa 200

riya   300

myra 400

 

Import Script :

 

.logon 127.0.0.1/dbc,dbc

.SET REPEATSTOP ON

.import  vartext ' ' file=/root/richa/tdpgms/example.out

.quiet on

.repeat *

using in_nm (varchar(5)),filler (char(1))

      ,in_reslt  (varchar(11))

  insert into retail.testdt

 (name,reslt)

  values

 (:in_nm ,:in_reslt);

 

.exit;

 

Retail.testdt defined as :

 

create table retail.testdt

(Name varchar(10),

reslt integer)

primary index (name);

 

Can anyone please help me in finding the error in bteq Import script.

 

Thank you

Richa

 

Santanu84 122 posts Joined 04/13
05 Jun 2014

Hi
Try below and reply whether it has worked.
remove filler (char(1))
change reslt varchar(11) in table
 
Thanks
Santanu

richa.prvr 9 posts Joined 09/12
05 Jun 2014

Hi,
Thank you.It worked :)
But can you please tell me the reason as why to change  change reslt varchar(11) in table. 
what difference does it made/ :( And as per my knowledge Teradata internally insert data as per datatype of columns.
Thanks,
Richa

Santanu84 122 posts Joined 04/13
05 Jun 2014

Good to hear that it has worked. You are right, the 2nd option is not required.
Just one curiosity , are you using TD 14 ?
Thanks
Santanu

richa.prvr 9 posts Joined 09/12
06 Jun 2014

yes, I am using TD14. Does that makes the difference?

You must sign in to leave a comment.