Problem faced while using FastLoad

Tools
N/A

Problem faced while using FastLoad

Hi All,

Here's a problem I am facing while using FastLoad.

I have exported five rows with just one field i.e. cust_id from the financial.customer table
using fastexport. I used the following script to generate the file "cust_id_list" in fastexport

--------------------------------------------------
.logtable financial.logtab121;

.logon ak/financial;

database financial;

.begin export;

.export outfile c:\tdat\cust_id_list;

select cust_id from financial.customer order by 1 where cust_id < 1362490;

.end export;

.logoff;
--------------------------------------------------

Then I created an empty table "financial.customer_new" from the "financial.customer" table

However, when I try to load the table "financial.customer_new" using the below script in FastLoad I get the below error.
Can anyone throw some light in this regard.

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

0001 .logon DemoTDAT/financial

.begin loading financial.customer_new ErrorFiles financial.Error_11, financial.E
rror_12;

define in_cust_id (integer)
file = C:\tdat\cust_id_list;

insert into financial.customer_new values (:in_cust_id);

Error message:

**** 20:16:51 Number of recs/msg: 7140
**** 20:16:51 Starting to send to RDBMS with record 1
**** 20:16:51 RECORD is too long by 1 byte(s)
Field 1: 348796160

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

Regards,
Manik
2 REPLIES
Teradata Employee

Re: Problem faced while using FastLoad

Default for FastExport is MODE INDICATOR (null flag bits at the start of each record) but default for FastLoad is no INDICATORS.

Either change the FastLoad
.begin loading financial.customer_new ErrorFiles financial.Error_11, financial.Error_12 INDICATORS;

or change the FastExport
.export outfile c:\tdat\cust_id_list MODE RECORD;
N/A

Re: Problem faced while using FastLoad

Hi Fred,

Yes your are right.
The moment I used the Indicator option in FastLoad, it worked.
Thanks for the quick help.

Regards,
Manik