Hi all,
I'm new to Fast Load and I'm looking for some expert advise. I've tried to load data into my table using CSV file as a FLAT FILE, but I keep getting the following errors ;
Number of rec/msg:7140
Start to send to RDBMS with record 1
RECORD is too long by 21311 bytes
Field 1: 168641609
Full scripts as follows;
sessions 8;
errlimit 250;
logon cda/userid
define cust_no (decimal(14,0))
file =X:\Use Id\Cust.CSV;
begin loading d_database.table
errorfiles d_database.err1, d_database.err2;
insert into d_database.table values(:cust_no);
**Number of rec/msg:7140
**Start to send to RDBMS with record 1
**RECORD is too long by 21311 bytes
**Field 1: 168641609
Can any please help?
Many thanks in advance?
Joe