实验环境:db2 v10.1
表名:
customers
表结构:
create table CUSTOMERS (
CUSTOMER_ID integer not null,
CUSTOMER_NAME varchar(50) not null,
CUSTOMER_PHONE varchar(20),
CUSTOMER_EMAIL varchar(50),
CUSTOMER_ADDRESS varchar(100),
DATE date,
CUSTOMER_PURCHASE XML,
DATA CLOB(1M),
primary key (CUSTOMER_ID)
);
ALTER TABLE customers APPEND ON;
准备文件:
-rwxr--r-- 1 db2inst1 db2grp1 21256080 2011-11-24 16:09 CUSTOMERS.del
-rwxr--r-- 1 db2inst1 db2grp1 214009939 2011-11-24 16:09 CUSTOMERS.del.001.lob
-rwxr--r-- 1 db2inst1 db2grp1 49738581 2011-11-24 16:09 CUSTOMERS.del.001.xml
查看CUSTOMERS.del的内容(只显示第一条记录):
1,"Claire Palmer","(265)731-1424","ClairePalmer@company9.com","1746 collegeview Ave. Sarnia N3R 8N5",20030424,"<XDS FIL='CUSTOMERS.del.001.xml' OFF='0' LEN='410' />","CUSTOMERS.del.001.lob.0.2615/"
其中:
<XDS FIL='CUSTOMERS.del.001.xml' OFF='0' LEN='410' /> 指定XML文件名
CUSTOMERS.del.001.lob.0.2615/ 指定LOB文件名
Import语法:
import from CUSTOMERS.del of del xml from ./ lobs from ./ COMMITCOUNT 5000 insert into CUSTOMERS;
其中:
xml from ./ 指定XML文件路径
lobs from ./ 指定LOB文件路径
添加新评论0 条评论