sqlldr end of file

Shell Programming and Scripting
1

Hi,
I've a batch program that load data from a file like:

00000013|FERRAN|JULIAN|GONZALEZ|1|
00000014|FRANCESC|NARVAEZ|PAZOS|1|
00000015|INMACULADA|MAYOL|BELTRAN|2|

I used the sqlldr command in this way:

sqlldr userid=U/P control=$SCRIPTS/CTRL.WCT data=$DATA/FILE log=$LOGS/FILE.LOG bad=$AUXS/FILE.BAD discard=$AUXS/FILE.DIS SKIP=1

Everythings works fine, but I notice that sometimes the rows on the file are more than the rows on the final DB table.
Sometimes occurs error on the precess.. wich kind of error I don't know.. basically I would like to know when the process reach the end of the document...
Thanks.

2

Could you paste contents of your control file(CTRL.WCT) as well?

3

Here it is..

LOAD DATA
INTO TABLE TAB
FIELDS TERMINATED BY "|"
TRAILING NULLCOLS
(
ID CHAR(3),
CA CHAR(12),
ES CHAR(12),
EN CHAR(12)
)