本文介绍如何处理XML数据的卸载与加载过程。当XML数据小于32K时，可以直接作为字符类型卸载；若超过32K，则需分别卸载普通数据与XML数据。文章详细解释了创建PDS模板进行XML数据卸载的方法，并说明了如何使用特定关键字从PDS中加载XML数据。
If XML data in the table is less than 32K for each record, then you can directly unload the data as char.
If XML data exceeds 32K for some records, then you have to unload the common data and the XML data separately.
First, create a template for unloading XML into a PDS:
TEMPLATE LOBFRV DSN 'AAA.BBB.LOB' DSNTYPE(PDS)
Then unload XML data using the template:
XMLDATA VARCHAR(12345) CLOBF LOBFRV
To load XML data from PDS, use “CLOBF” keyword to indicate that the column will be loaded from file, and POSITION(122:150) indicates the file name location in the record file.
XMLDATA POSITION(122:150) CHAR CLOBF
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
