-- sqlldr userid=uwclass/uwclass control=c:\temp\demo06.ctl log=c:\temp\demo06.log direct=true

LOAD DATA
INFILE 'c:\temp\demo06.dat'
INSERT
INTO TABLE emp
-- SORTED INDEXES (emp_empno) 
(
empno	POSITION(01:04)	INTEGER EXTERNAL NULLIF empno=BLANKS,
ename	POSITION(06:15)	CHAR,
job	POSITION(17:25) CHAR,
mgr	POSITION(27:30)	INTEGER EXTERNAL NULLIF mgr=BLANKS,
sal	POSITION(32:39)	DECIMAL EXTERNAL NULLIF sal=BLANKS,
comm	POSITION(41:48)	DECIMAL EXTERNAL NULLIF comm=BLANKS,
deptno	POSITION(50:51) INTEGER EXTERNAL NULLIF deptno=BLANKS)