DB2 中读取clob类型

最新推荐文章于 2022-04-11 14:18:11 发布

iteye_9715

最新推荐文章于 2022-04-11 14:18:11 发布

阅读量2.3k

点赞数

分类专栏：贴士文章标签： DB2 SQL Access XML IBM

贴士专栏收录该内容

10 篇文章

订阅专栏

读取clob类型的xml数据：

export to xml.del of del lobfile xml modified by lobsinfile select requested_elements_clob from req.access_req_v where request_id in (14, 15);

写入clob类型的xml数据：

import from '/home/team1adm/autoDBA/importXMLCLOB_FIW.del' of del lobs from '/home/team1adm/autoDBA' modified by lobsinfile insert_update into req.access_req_xml_clob;

importXMLCLOB_FIW.del：

2056579, "2056579.req.0.35192/"
2056588, "2056588.req.0.48122/"

Big file out:

INSERT INTO REQ.ACCESS_REQ (app_code, serial, cc, userid, request_id, top_level_element, USERID_TYPE, REQ_SERIAL, REQ_CC, SYSTEM, request_type, status, status_updated_by, referred_request_id, timestamp, status_updated_date, business_justification, REQUESTED_ELEMENTS) VALUES ('FIW_LR', '908749', 'JPG', 'J908749', 2056579, 'Geo_Country_LC_LD', 'HYPERION', 'C-3M2F', '897', '', 'MIGRATED', 'GRANTED', 'oneteam@us.ibm.com', 0, CURRENT TIMESTAMP, CURRENT TIMESTAMP, 'MIGRATED USER', null);
INSERT INTO REQ.ACCESS_REQ (app_code, serial, cc, userid, request_id, top_level_element, USERID_TYPE, REQ_SERIAL, REQ_CC, SYSTEM, request_type, status, status_updated_by, referred_request_id, timestamp, status_updated_date, business_justification, REQUESTED_ELEMENTS) VALUES ('FIW_LR', '8A0735', '897', 'GMEGHAN', 2056588, 'Geo_Country_LC_LD', 'HYPERION', 'C-3M2F', '897', '', 'MIGRATED', 'GRANTED', 'oneteam@us.ibm.com', 0, CURRENT TIMESTAMP, CURRENT TIMESTAMP, 'MIGRATED USER', null);

import from 'D:\tmp\FIW\xxx\importXMLCLOB_FIWLR.del' of del lobs from 'D:\tmp\FIW\xxx' modified by lobsinfile insert into req.access_req_xml_clob;