db2 load

load
from 'infile.txt'
--------------------------------------
of asc
modified by dumpfile='error.log'
method L (1 5,6 15,16 20,24 27)
messages e:\messages.log
insert into tablename
(col1,
col2,
col3,
col4)
for exception liwaibiao-name

--------------------------------------

--------------------------------------
of del
modified by coldel, chardel'' dumpfile='error.log'
method p (1,2,3,5)
messages e:\messages.log
replace into tablename
(col1,col2,col3,col4)
for exception liwaibiao-name
--------------------------------------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7338183/viewspace-660719/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7338183/viewspace-660719/