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



LOAD DATA

INFILE 'c:\temp\demo10.dat'

INTO TABLE emp

REJECT ROWS WITH ALL NULL FIELDS

(empno	POSITION(01:04)		INTEGER EXTERNAL,

 ename	POSITION(06: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)