All Forums Tools
02CSE33 11 posts Joined 03/13
21 Apr 2013
Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ

Hi Gurus,
Now I am able to login properly in both Batch as well as Interactive mode through BTEQ.
The problem which I am facing is with IMPORT of data to Database.
Details of the IMPORT.

.IMPORT vartext '|'  FILE=/home/dsadm/Automation/fact_data_run1.txt;
        .REPEAT *
        USING
        REPORT_NAME     (VARCHAR(50)),
        SUB_REPORT_NAME (VARCHAR(100)),
        OPTIONAL_FLAG   (VARCHAR(1)),
        DATA_DATE       (VARCHAR(20)) ,
        PROCESS_DATE    (VARCHAR(20)) ,
        Load_START      (VARCHAR(20)) ,
        Load_END        (TIMESTAMP(0)) ,
        IS_WEEKLY       (VARCHAR(20)) ,
        IS_MONTHLY      (VARCHAR(20)),
        FAILURE         (VARCHAR(20)),
        FAILURE_SR      (VARCHAR(20)),
        FAILURE_REASON  (VARCHAR(1000)),
        RAG_STATUS      (VARCHAR(20)),
        HAD_DELAY       (VARCHAR(20)),
        DELAY_REASON    (VARCHAR(20)),
        UPDATED_BY      (VARCHAR(20))


        INSERT INTO NDW_ETL_WORK.NDW_REPORT_FACT (REPORT_NAME, SUB_REPORT_NAME,OPTIONAL_FLAG,DATA_DATE,PROCESS_DATE,L oad_START,Load_END,IS_WEEKLY,IS_MONTHLY,FAILURE,
        FAILURE_SR,FAILURE_REASON,RAG_STATUS,HAD_DELAY,DELAY_R EASON,UPDATED_BY)
        values
        (
                :REPORT_NAME,
                :SUB_REPORT_NAME,
                :OPTIONAL_FLAG,
  CAST(:DATA_DATE AS DATE),
                CAST(:PROCESS_DATE AS DATE),
                CAST(:Load_START AS TIME(0)),
                CAST(:Load_END AS TIME(0)),
                :IS_WEEKLY,
                :IS_MONTHLY,
                :FAILURE,
                :FAILURE_SR,
                :FAILURE_REASON,
                :RAG_STATUS,
                :HAD_DELAY,
                :DELAY_REASON,
                :UPDATED_BY
        );

Sample Record: [ There is end of line in the source file, i.e. cursor will point to begining of next line]

SUBSCRIBER_REPORT|SUBSCRIBER_REPORT|N|2013-03-12|2013- 03-13|12:30:00 AM|04:35:00 AM|N|N|N|N|N|GREEN|N|N|SYSTEM

Table Def :

CREATE SET TABLE NDW_ETL_WORK.NDW_REPORT_FACT ,FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      REPORT_NAME VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
      SUB_REPORT_NAME VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
      OPTIONAL_FLAG CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC CHECK ( OPTIONAL_FLAG  IN ('Y','N') ),
      DATA_DATE DATE FORMAT 'YYYY-MM-DD' NOT NULL ,
      PROCESS_DATE DATE FORMAT 'YYYY-MM-DD' NOT NULL,
      Load_START TIMESTAMP(0),
      Load_END TIMESTAMP(0),
      IS_WEEKLY CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC CHECK ( IS_WEEKLY  IN ('Y','N') ),
      IS_MONTHLY CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC CHECK ( IS_MONTHLY  IN ('Y','N') ),
      FAILURE CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC CHECK ( FAILURE  IN ('Y','N') ),
      FAILURE_SR VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
      FAILURE_REASON VARCHAR(1000) CHARACTER SET LATIN NOT CASESPECIFIC,
      RAG_STATUS VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
      HAD_DELAY CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC CHECK ( HAD_DELAY  IN ('Y','N') ),
      DELAY_REASON VARCHAR(1000) CHARACTER SET LATIN NOT CASESPECIFIC,
      UPDATED_BY VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL)
UNIQUE PRIMARY INDEX NDW_REPORT_FACT_UPI ( REPORT_NAME ,SUB_REPORT_NAME ,
DATA_DATE );

Now while executing, the BTEQ I am receiving the following error:
 *** Failure 2673 The source parcel length does not match data that was defined.
                Statement# 1, Info =1
 *** Failure 2673 The source parcel length does not match data that was defined.
                Statement# 1, Info =1
 *** Warning: Out of data.
All the data sets are moving as rejected record.
Can you please suggest me on this. As now I am really stuck.
:(

Regards, Sudipta
dnoeth 4628 posts Joined 11/04
21 Apr 2013

Hi Sudipta,
the error is obvious, you define Load_END as a TIMESTAMP instead of VARCHAR :-)
You should also add a FORMAT to the cast to TIME due to AM/PM:
CAST(:Load_END AS TIME(0) FORMAT 'hh:mi:ssBt'),
And you should add a PACK (if there are no errors in your input data) to get a faster load.
Dieter
 

Dieter

02CSE33 11 posts Joined 03/13
21 Apr 2013

Hi Dieter,
I am really puzzled with Timestamp handling.
I have re-arranged my data as :

SUBSCRIBER_REPORT|SUBSCRIBER_REPORT|N|2013-03-12|2013-03-13|2013-03-13 12:30:00|2013-03-13 04:35:00|N|N|N|N|N|GREEN|N|N|SYSTEM

In USING part of IMPORT i have made the ammendments as VARCHAR as suggested:

 Load_START      (VARCHAR(20)) ,
 Load_END        (VARCHAR(20)) ,

In the INSERT query i have used the following:

 CAST(:Load_START AS TIME(0)FORMAT 'yyyy-mm-dd hh:mi:ss'),
 CAST(:Load_END AS TIME(0)FORMAT 'yyyy-mm-dd hh:mi:ss'),

And now the PARCEL LENGHT error is fixed but receiving invalid time error:

 *** Warning: Out of data.
 *** Failure 3530 Invalid FORMAT string 'yyyy-mm-ddhh:mi:ss'.
Statement# 1, Info =0

Can you please suggest on this.
Also if you have any posts/articles for Date Time arithmetic in Teradata, it will be really helpfull for me.

Regards,
Sudipta

dnoeth 4628 posts Joined 11/04
21 Apr 2013

Hi Sudipta,
there are different datatypes in Teradata for DATE, TIME and TIMESTAMP.
When you cast a string to a time you can't use a date part, when you cast to a date you can't use a time part.
In your case either keep data as is and use the cast i showed or use the rearranged data and cast to a timestamp.
And because the FORMAT is based on Cobol you must use a 'B' instead of a blank in the format string: yyyy-mm-ddBhh:mi:ss
 
You'll find a lot about working with DateTime datatypes scattered throughout the manuals and there's an old article written by Geoffrey Rommel on the TeradataForum website covering the basics: http://www.teradataforum.com/l081007a.htm
It's a bit outdatet, as there are more advanced datatypes/functions, but there are two good articles on PERIODs by Rob Garrison:
http://developer.teradata.com/database/articles/exploring-teradata-13s-period-functions
 
Dieter

Dieter

11 Jul 2013

hi guys,
 
im the below export script to export data,

.logon xxxxxxxx/students,learning13

 

.export data file= c:/au/data33_4

 

sel

 

trim(cast(cast(account_number as format 'z(i)') as varchar(10))),

trim(cast(cast(number as format 'z(i)') as varchar(10))),

trim(cast(street as varchar(30))),

trim(cast(city as varchar(30)) ),

trim(cast(state as char(2))), 

trim(cast(zip_code as varchar(30))),

trim(cast(cast(balance_forward as format 'z(i)') as varchar(20))),

trim(cast(cast(balance_current as format 'z(i)') as varchar(20))) 

 

from ap.accounts;

 

.export reset

 
.quit
 
and using the below script to import it,

.logon xxxxxxxxxx/students,learning13

 

DELETE FROM STUDENTS.ACCOUNTS1 ALL;

.import data file= c:/au/data33_4

 

.quite on

.repeat * pack 1000

 

using(

in_account_number   varchar(10),

in_number           varchar(10),

in_street           varchar(30),

in_city             varchar(30),

in_state            char(2),

in_zip_code         varchar(30),

in_balance_forward  varchar(20),

in_balance_current  varchar(20) )

 

INSERT INTO STUDENTS.ACCOUNTS1 

VALUES ( 

cast(:in_account_number as integer),

cast(:in_number as integer), 

cast(:in_street as char(25)),

cast(:in_city as char(20)),

:in_state,

cast(:in_zip_code as integer),

cast(:in_balance_forward as decimal(10,2)),

cast(:in_balance_current as decimal(10,2))

);

 

.quite off
.quit 
 
im gettin the error,
the source parcel lenght does not match the data that was defined.
 
can anyone help me here????

Manjunath.M

dnoeth 4628 posts Joined 11/04
11 Jul 2013

Hi Manjunath.M,
when you TRIM a CHAR(2) i changes to a VARCHAR(2).
You can either

  • remove the trim
  • export using CAST(TRIM(state) AS CHAR(2)) or
  • import using in_state            varchar(2),

Btw, it's "quiet on/off" , not "quite on/off" :-)

 

Dieter

Dieter

12 Jul 2013

Dieter,
Thanks a lot , this worked :) 

Manjunath.M

malli111 22 posts Joined 06/15
20 Jun 2015

Hi All,
 
I am new to teradata. I am importing data from text file into table.
Text file data:
1,a,3

2,b,4

 

Logic:

 

logon username/password;

database dbname;

.IMPORT VARTEXT ','  FILE='/users/mbukkala/e2.txt'

.QUIET ON  

.repeat *

using

dno(INTEGER),

dname(VARCHAR(200)),

eno(INTEGER)

insert into supportdb.tdp(dno,dname,eno) values(:dno,:dname,:eno);

.logoff;

.quit;

 

i am getting below error

 

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

 

Please help me

 

Thans in advance

Malli

 

dnoeth 4628 posts Joined 11/04
20 Jun 2015

Hi Malli,
when you define VARTEXT all fields in USING must be VARCHARs:

using
dno (VARCHAR(11)),
dname(VARCHAR(200)),
eno(VARCHAR(11))

 

Dieter

malli111 22 posts Joined 06/15
21 Jun 2015

HI Dieter,
Thanks you so much its worked.
One more doubt:  i am exporting data in all modes.But incase of .EXPORT DIF mode i am unable to get column names in the result set.
Please help me on this
 
Thanks in advance,
Malli

dnoeth 4628 posts Joined 11/04
21 Jun 2015

Hi Malli,
DIF is an ancient format (from the ages of Multiplan and Lotus 1-2-3), why do you want to use it anyway?

Dieter

malli111 22 posts Joined 06/15
21 Jun 2015

HI Dieter,

 

Thank you so much for quick reply.

My requirement is i have to export 500 records data from table to excel sheet with column names as well.But data loading, column names not coming. Please help on this.

 

Thanks in advance

Mallik

malli111 22 posts Joined 06/15
21 Jun 2015

HI ALL,
 
My text file like below format:
133232      mallik            6678783       980920
133342      anil                6678783       980920
133232      ravi                6678783       980920
 
i dont how much space for each gap. which delimetr i have to use with VARTEXT ?  [in BTEQ IMPORT].
 
Please help me .
Thanks in advance
Malli

dnoeth 4628 posts Joined 11/04
21 Jun 2015

Hi Mallik,
in the exported DIF there's info about the column names, but Excel doesn't seem to use it. DO you need to run this export in a batch or manually? SQL Assistant can create Excel-files, run the query, CTRL-S and choose Excel 2003 or 2007.
 
Regarding the last format, this is fixed width, try REPORT format and define CHARs instead of VarChar. 

Dieter

malli111 22 posts Joined 06/15
21 Jun 2015

Hi Dieter,
Thanks for your help first request worked.
For second one below is the .xls  data:
133232      mallik            6678783       980920
133342      anil                6678783       980920
133232      ravi                6678783       980920
 
Logic:
.logon tdprod/e_service_batch,o123$_1_1_12_9_8;

database supportdb;

.IMPORT REPORT FILE='/users/mbukkala/e108.xls';

.QUIET ON 

.PACK 

.REPEAT *

USING

ipkey(CHAR(50)),

ipname (CHAR(200)),

ownerkey (CHAR(50)),

rukey (CHAR(50))

insert into supportdb.tdp4 values(:ipkey,:ipname,:ownerkey,:rukey);

.logoff;

.quit;

 

Still i am getting the below error pls help me

 

 *** Failure 2673 The source parcel length does not match data that was defined.

 

Thanks in advance

Malli

malli111 22 posts Joined 06/15
23 Jun 2015

HI ALL,
can any one help on the above issue.
 
Thanks in advance.
Malli

TDThrottle 51 posts Joined 11/11
23 Jun 2015

When using fixed length input file, variable declaration should match the table layout and inputfile characters.

 

133232      mallik              6678783       980920

133342      anil                6678783       980920

133232      ravi                6678783       980920

 

From given input file, guestimate the column length should be near close to:

Adjust the length based on exact input file format

 

ipkey (CHAR(13)),

ipname (CHAR(20)),

ownerkey (CHAR(14)),

rukey (CHAR(6))

malli111 22 posts Joined 06/15
27 Jun 2015

Hi TDThrottle,
Thank you so much It is worked.
 
One more doubt is    in oracle we have DUAL is the temporary table, like this TERADATA
Having any table?
Please help me
 
Thank you,
Malli
 

malli111 22 posts Joined 06/15
27 Jun 2015

Hi Dieter/TDThrottle/ALL,
 
Please clarify below doubts:
1. in oracle we have DUAL is the temporary table, like this TERADATA Having any table?
2. i defined varchar(50)  but my value is not morethan 20 characters. what will happen remianing size ? is it automatically saved or some thing else ?
3. Why we ill not use VARCHAR in case of COMPRESS technique ?
 
Please help me on above doubts.
Thank you so much in advance.
Mallik.
 
 

dnoeth 4628 posts Joined 11/04
28 Jun 2015

Hi Mallik,
Q1: There's no need for DUAL as you don't need FROM: SELECT 1;
Q2: The name VarChar (= Character Varying) implies variable size
Q3: You can compress VarChars since TD13.10

Dieter

malli111 22 posts Joined 06/15
28 Jun 2015

Hi Dieter,
 
Thank you so much for your help.
 
Thanks,
Malli

malli111 22 posts Joined 06/15
29 Jun 2015

Hi Dieter,
 
Teradata stored procedure always one AMP operation ?
is it good to use ?
Please confirm
Thank you so much in advance.
Mallik
 

malli111 22 posts Joined 06/15
30 Jun 2015

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

dnoeth 4628 posts Joined 11/04
30 Jun 2015

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

Dieter

malli111 22 posts Joined 06/15
02 Jul 2015

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

dnoeth 4628 posts Joined 11/04
05 Jul 2015

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.

Dieter

malli111 22 posts Joined 06/15
12 Jul 2015

Hi Dieter,

Thank you so much.

malli111 22 posts Joined 06/15
12 Jul 2015

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

dnoeth 4628 posts Joined 11/04
13 Jul 2015

Hi Malli,
again: 
please post a new question in a new thread.

Dieter

malli111 22 posts Joined 06/15
19 Jul 2015

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

malli111 22 posts Joined 06/15
20 Jul 2015

Hi 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

malli111 22 posts Joined 06/15
20 Jul 2015

Hi All,
 
Thanks you so much, i found option to create new thread.
 
Thanks,
Malli

dge2108 1 post Joined 03/16
03 Mar 2016

Hi,
 
im the below export script to export data, below is the .txt  data

.IMPORT VARTEXT '|' FILE=D:\REPAUTO\Archivos_Base\schtasks.txt

.QUIET ON

.REPEAT *

USING(

      HOSTNAME VARCHAR(25),

      TASKNAME VARCHAR(200) , ---

      NEXTRUN VARCHAR(50) ,

      STATUS VARCHAR(30) ,

      LOGONMODE VARCHAR(50) ,

      LASTRUN VARCHAR(50) ,

      LASTRESULT VARCHAR(50) ,

      AUTHOR VARCHAR(30) ,

      TASKRUN VARCHAR(200), --      

      STARTIN VARCHAR(100) , 

      COMMENTS VARCHAR(500) , -- 

      TASKSTATE VARCHAR(100) ,      

      IDLETIME VARCHAR(200) ,  

      POWERMANAG VARCHAR(200) , 

      RUNASUSER VARCHAR(80) ,

      DELETETASK VARCHAR(80) , 

      STOPTASK VARCHAR(200) , 

      SCHEDULE VARCHAR(100) ,

      SCHEDULETYPE VARCHAR(100) ,

      STARTTIME VARCHAR(60) ,

      STARTDATE VARCHAR(60) ,

      ENDDATE VARCHAR(60) ,

      DAYS VARCHAR(100) ,

      MONTHS VARCHAR(100) ,    

      R1 VARCHAR(50) ,

      R2 VARCHAR(50) ,

      R3 VARCHAR(50) ,

      R4 VARCHAR(50) 

)

INSERT INTO VISU.GI09203_DE_TAREAS_PROG_I

  (   HOSTNAME,

      TASKNAME,

      NEXTRUN,

      STATUS,

      LOGONMODE,

      LASTRUN,

      LASTRESULT,

      AUTHOR,     

      TASKRUN,

      STARTIN,

      COMMENTS,

      TASKSTATE,

      IDLETIME,

      POWERMANAG,

      RUNASUSER,

      DELETETASK,      

      STOPTASK,      

      SCHEDULE,

      SCHEDULETYPE,

      STARTTIME,

      STARTDATE,

      ENDDATE,

      DAYS,

      MONTHS,

      R1,

      R2,

      R3

  )

VALUES(

  trim(:HOSTNAME), 

  trim(:TASKNAME),

  trim(:NEXTRUN)

  ,trim(:STATUS)

  ,trim(:LOGONMODE)

  ,trim(:LASTRUN)

  ,trim(:LASTRESULT)

  ,trim(:AUTHOR)

  ,trim(:TASKRUN)

  ,trim(:STARTIN)

  ,trim(:COMMENTS)

  ,trim(:TASKSTATE)

  ,trim(:IDLETIME)

  ,trim(:POWERMANAG)

  ,trim(:RUNASUSER)

  ,trim(:DELETETASK)

  ,trim(:STOPTASK)

  ,trim(:SCHEDULE)

  ,trim(:SCHEDULETYPE)

  ,trim(:STARTTIME)

  ,trim(:STARTDATE)

  ,trim(:ENDDATE)

  ,trim(:DAYS)

  ,trim(:MONTHS)

  ,trim(:R1)

  ,trim(:R2)

  ,trim(:R3)

  );

.IF ERRORCODE <> 0 THEN .GOTO ENCONTRO_ERRORES

 

--------------------------------------------------------------------------------------------------------------

.LOGOFF

.QUIT 0

 

.LABEL ENCONTRO_ERRORES

.LOGOFF

.QUIT 1
 
im getting the error in the .log:
*** Failure 2673 The source parcel length does not match data that was defined.                Statement# 1, Info =6 
 *** Total elapsed time was 1 second.
 
Can anyone help me, please?
 
Regards,

np186031 1 post Joined 12/15
11 Apr 2016

I am also facing the same problem.
I am trying to upload CLOB from flat file to some table and constantly getting "parcel length error".
 
/* bteq script I am using */
.logon my_machine/usr,pass;

database dummy_db;

.IMPORT VARTEXT ',' LOBCOLS=1 FILE=arg_list.txt;
USING (case_id varchar(64), suite_id varchar(3), sql_text CLOB AS DEFERRED, result_row_cnt varchar(3))
INSERT INTO dummy_db.test_case(case_id, suite_id, sql_text, result_row_cnt) values(:case_id, :suite_id, :sql_text, :result_row_cnt);

.logoff;
.quit;
 
/* table I want to upload to*/
CREATE SET TABLE DUMMY_DB.test_case ,FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      Case_ID VARCHAR(64) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      SQL_Text CLOB(2097088000) CHARACTER SET LATIN NOT NULL,
      suite_id VARCHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC,
      result_row_cnt VARCHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC)
UNIQUE PRIMARY INDEX ( Case_ID );
/* arg_list.txt that i am reading from contains*/
PCTRPT_DR103259_qryid001,5,PCTRPT_DR103259_qryid001.txt,0
where "PCTRPT_DR103259_qryid001.txt" file that contains very large text.
 
/* here is my bteq output */
BTEQ 15.00.00.01 Mon Apr 11 19:19:11 2016 PID: 10380
 
+---------+---------+---------+---------+---------+---------+---------+----
.logon my_machine/usr,

 *** Logon successfully completed.
 *** Teradata Database Release is 16p.00.00.58                  
 *** Teradata Database Version is 16p.00.00.58_dr179641br1_3      
 *** Transaction Semantics are BTET.
 *** Session Character Set Name is 'ASCII'.
 
 *** Total elapsed time was 3 seconds.
 
+---------+---------+---------+---------+---------+---------+---------+----

database dummy_db;

 *** New default database accepted.
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

.IMPORT VARTEXT ',' LOBCOLS=1 FILE=arg_list.txt;
+---------+---------+---------+---------+---------+---------+---------+----
USING (case_id varchar(64), suite_id varchar(3), sql_text CLOB AS DEFERRED,
 result_row_cnt varchar(3))
INSERT INTO dummy_db.test_case(case_id, suite_id, sql_text, result_row_cnt
) values(:case_id, :suite_id, :sql_text, :result_row_cnt);
 *** Failure 2673 The source parcel length does not match data that was defi
 ned.
                Statement# 1, Info =4
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

.logoff;
 *** You are now logged off from the DBC.
+---------+---------+---------+---------+---------+---------+---------+----
.quit;
 *** Exiting BTEQ...
 *** RC (return code) = 8
 
I have tried reading several post but couln`t understand what I am doing wrong.
I think I am making some mistake in loading CLOB file, BTW I am new to teradata so any help would be appreciated.
 
Thanks
 

 

You must sign in to leave a comment.