db2 load 用法及日志归档

xiaoxiao2021-02-28  25

存储过程 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;

 

 

转载请注明原文地址: https://www.6miu.com/read-2627210.html

最新回复(0)