|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/17/2007 4:54:00 AM
Posts: 7,
Visits: 1
|
|
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
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Yesterday @ 4:20:22 PM
Posts: 327,
Visits: 504
|
|
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;
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/17/2007 4:54:00 AM
Posts: 7,
Visits: 1
|
|
Hi Fred,
Yes your are right.
The moment I used the Indicator option in FastLoad, it worked.
Thanks for the quick help.
Regards,
Manik
|
|
|
|