OPTIONS (LOG=LOB.LOG,BAD=LOB.BAD,ROWS=100,ERRORS=-1,BINDSIZE=1024000)
LOAD DATA
INFILE LOB.TXT
APPEND
INTO TABLE YEAR2002
WHEN YEAR='2002'
FIELDS TERMINATED BY X'09'
TRAILING NULLCOLS
(YEAR FILLER POSITION(1:4),A,B)
INTO TABLE YEAR2003
WHEN YEAR='2003'
FIELDS TERMINATED BY X'09'
TRAILING NULLCOLS
(YEAR FILLER POSITION(1:4),A,B)
LOAD DATA
INFILE LOB.TXT
APPEND
INTO TABLE YEAR2002
WHEN YEAR='2002'
FIELDS TERMINATED BY X'09'
TRAILING NULLCOLS
(YEAR FILLER POSITION(1:4),A,B)
INTO TABLE YEAR2003
WHEN YEAR='2003'
FIELDS TERMINATED BY X'09'
TRAILING NULLCOLS
(YEAR FILLER POSITION(1:4),A,B)
如:
LOAD DATA
INFILE *
REPLACE
INTO TABLE emp
WHEN empno != ' '
( empno POSITION(1:4) INTEGER EXTERNAL,
ename POSITION(6:15) CHAR,
deptno POSITION(17:18) CHAR,
mgr POSITION(20:23) INTEGER EXTERNAL
)
INTO TABLE proj
WHEN projno != ' '
( projno POSITION(25:27) INTEGER EXTERNAL,
empno POSITION(1:4) INTEGER EXTERNAL
)
LOAD DATA
INFILE *
APPEND
INTO TABLE A
WHEN WHO='1'
FIELDS TERMINATED BY X'09' (WHO FILLER POSITION(1:1),KK)
INTO TABLE B
WHEN WHO='1'
FIELDS TERMINATED BY X'09' (WHO FILLER POSITION(1:1),KK)
BEGINDATA
1A
1B