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



LOAD DATA

INFILE 'c:\temp\demo09a.dat'

INFILE 'c:\temp\demo09b.dat'

APPEND

INTO TABLE denver_prj

WHEN projno = '101'

 (projno  position(1:3) CHAR,

  empno   position(4:8) INTEGER EXTERNAL,

  projhrs position(9:10) INTEGER EXTERNAL)



INTO TABLE orlando_prj

WHEN projno = '202'

 (projno  position(1:3) CHAR,

  empno   position(4:8) INTEGER EXTERNAL,

  projhrs position(9:10) INTEGER EXTERNAL)



INTO TABLE misc_prj

WHEN projno != '101' AND projno != '202'

 (projno  position(1:3) CHAR,

  empno   position(4:8) INTEGER EXTERNAL,

  projhrs position(9:10) INTEGER EXTERNAL)