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
--------------------------------------
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博客 ” ，链接：https://blog.itpub.net/7338183/viewspace-660719/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
db2 hadr 管理
下一篇：
db2 study
请登录后发表评论
登录
全部评论
