I have written a fastexport to export data with 'FORMAT text MODE record'. I get some extra bytes (^_^@)at the begining of each record. That is creating problem in loading the file. If i remove it, load works fine.
my exported data:
in the export , i have Date field and timestamp filed.
In the fload , i have specified :
PAGE_VIEW_DT (VARCHAR(50)) ,
insert into idw_bkup.WEB_PAGE_VIEW_T_stage1
I get an error : Not enough fields in vartext data record 1
Please help !!
can't really share the scripts...
i have used .SET RECORD VARTEXT "|";
in the fload.
in the fastexport i am using
.EXPORT OUTFILE fexp.bat FORMAT text MODE record;
locking ROW for access
trim(cast(VIEW_DT as varchar(50))) || '|' ||
trim(cast(LOAD_TS as varchar(50))) as varchar(2100) ) )
The export script:
.SET RECORD VARTEXT "|";
drop table err2;
VIEW_DT (VARCHAR(50)) ,
begin loading stage_tab
checkpoint 0 ;
insert into stage_tab