`
mabusyao
  • 浏览: 247822 次
  • 性别: Icon_minigender_1
  • 来自: 南京
社区版块
存档分类
最新评论

DB2 中读取clob类型

阅读更多
读取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;


分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics