OPTIONS ( SKIP=1 LOAD=ALL ROWS=64 DISCARDMAX=100 ERRORS=50 ) LOAD DATA INFILE 'qwertz.dat' LOGFILE 'qwertz.log' BADFILE 'qwertz.bad' DISCARDFILE 'qwertz.dsc' TRUNCATE --alternativ: APPEND INTO TABLE qwertzuiop WHEN (1) <> '#' ( zahl1 POSITION (01:10) INTEGER EXTERNAL, zahl2 POSITION (11:30) DECIMAL EXTERNAL, zahl3 POSITION (31:50) FLOAT EXTERNAL, text POSITION (51:100) CHAR, datum POSITION (101:110) DATE "DD.MM.YYYY" datumzeit POSITION (111:129) TIMESTAMP "DD.MM.YYYY HH24:MI:SS" )