Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Tools & Utilities
Enthusiast

Re: Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Hi Dieter,

Thank you so much for your help.

Thanks,

Malli

Enthusiast

Re: Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Hi Dieter,

Teradata stored procedure always one AMP operation ?

is it good to use ?

Please confirm

Thank you so much in advance.

Mallik

Enthusiast

Re: Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Hi All,

Please help me on below doubts:

1.Teradata stored procedure always one AMP operation ?

2. Tpump having phases(preliminary,DML,aquisistion,application,end/cleanup phases) like Mload ?

3. Howmany error tables in Tpump?

Thank you so much in advance.

Mallik

Ambassador

Re: Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Hi Mallik,

please post a new question in a new thread.

Q1: The control statements within an SP (LOOP, IF, etc.) run on a single node, but the queries run exactly the same as standalone SQL.

Q2: No, please check the TPump manual

Q3: 1, please check the TPump manual

Highlighted
Enthusiast

Re: Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Hi Dieter,

Thank you so much for the help.Sure i will go with new thread for new question.

Please help me on below doubt:

Does sdlc changes when you use teradata instead of oracle ?

Thank you so much in advance.

Mallik

Ambassador

Re: Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Sure i will go with new thread for new question.

I actually didn't notice that this is a new topic.

Does sdlc changes when you use teradata instead of oracle ?

Probably not.

Enthusiast

Re: Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Hi Dieter,

Thank you so much.
Enthusiast

Re: Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Hi Dieter,

can you please help me to load the data from two files to single target table using FASTLOAD.

below is the code:

sessions 2;
errlimit 25;
.logon username/password;
database supportdb;
drop table SUPPORTDB.emp_f1;
drop table supportdb.err_f1;
drop table supportdb.uv_f1;

CREATE TABLE SUPPORTDB.emp_f1
(
eno NUMBER(10,0),
ename VARCHAR(30),
sal NUMBER(10,0))
PRIMARY INDEX ( eno );

.SET RECORD VARTEXT ",";

define
eno (VARCHAR(30)),
ename (VARCHAR(30)),
sal (VARCHAR(30))

file='/users/mbukkala/practice_fastload/i3.txt';
show;
begin loading supportdb.emp_f1 errorfiles supportdb.err_f1,supportdb.UV_f1;
insert into supportdb.emp_f1 values
(
:eno,
:ename,
:sal)
;

LOGOFF;

.logon username/password;
database supportdb;
.SET RECORD VARTEXT ",";

define
eno (VARCHAR(30)),
ename (VARCHAR(30)),
sal (VARCHAR(30))

file='/users/mbukkala/practice_fastload/i4.txt';
show;
begin loading supportdb.emp_f1 errorfiles supportdb.err_f2,supportdb.UV_f2;
insert into supportdb.emp_f1 values
(
:eno,
:ename,
:sal)
;

.end loading;

.logoff;
.quit;

Thanks,
Malli
Ambassador

Re: Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Hi Malli,

again: 

please post a new question in a new thread.

Enthusiast

Re: Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Hi Dieter/All,

I am unable to create new thread. Where is the option to create new  thread.

Please help me 

Thank you so much in advance

Regards,

Mallik