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

LOAD DATA
INFILE 'c:\temp\demo05.dat'
BADFILE 'c:\temp\bad05.bad'
DISCARDFILE 'c:\temp\disc05.dsc'
REPLACE

INTO TABLE emp (
empno	POSITION(1:4)	INTEGER EXTERNAL,
ename	POSITION(6:15)	CHAR,
deptno	POSITION(17:18)	CHAR,
mgr	POSITION(20:23)	INTEGER EXTERNAL)

--1st project: proj has two columns, both not null
INTO TABLE proj
WHEN projno != '   ' (
emp	POSITION(1:4)	INTEGER EXTERNAL,
projno	POSITION(25:27)	INTEGER EXTERNAL)

-- 2nd project
INTO TABLE proj
WHEN projno != '   ' (
emp	POSITION(1:4)	INTEGER EXTERNAL,
projno	POSITION(29:31)	INTEGER EXTERNAL)

-- 3rd project
INTO TABLE proj
WHEN projno != '   ' (
emp	POSITION(1:4)	INTEGER EXTERNAL,
projno	POSITION(33:35)	INTEGER EXTERNAL)