-- sqlldr userid=uwclass/uwclass control=c:\temp\demo04.ctl log=c:\temp\demo04.log

LOAD DATA
INFILE 'c:\temp\demo04.dat'
DISCARDFILE 'c:\temp\demo04.dsc'
DISCARDMAX 999
REPLACE
CONTINUEIF THIS (1) = '*'
INTO TABLE emp (
empno		POSITION(1:4)	INTEGER EXTERNAL,
ename		POSITION(6:15)	CHAR,
job		POSITION(17:25)	CHAR,
mgr		POSITION(27:30)	INTEGER EXTERNAL,
sal		POSITION(32:39)	DECIMAL EXTERNAL,
comm		POSITION(41:48)	DECIMAL EXTERNAL,
deptno		POSITION(50:51)	INTEGER EXTERNAL,
hiredate	POSITION(52:60)	INTEGER EXTERNAL)