db2 load 用法及日志归档

存储过程 load 的用法

load from (database  TSISSDB  select * from TD_ENUMVALUETEST)   of cursor warningcount 1

INSERT INTO TD_ENUMVALUE (S_TYPECODE, S_VALUE, S_VALUECMT, C_ISAVAILABLE, S_REMARK)

COPY YES TO /tsishdb/loadtmp DATA BUFFER 32767  ALLOW READ ACCESS LOCK WITH FORCE;

load client from D:\TD_ENUMVALUETEST.del of del modified by codepage =1386

dumpfile=D:\tsishdb\loadtmp\tt.txt messages D:\tsishdb\loadtmp\tt.txt  insert into TG_DEBT_TRADE

for exception  TG_DEBT_TRADE ALLOW READ ACCESS;