Scenario
On a daily basis, the clinic moves data to a data warehouse for data mining. The business intelligence team runs reports on the clinical data to mine for statistics.
Pre-requistesOperation
DB2 data movement utilities such as EXPORT and IMPORT utilities are used to export and import regular and XML data.
Solution
XML data is moved into flat files in directories 'XMLDataMoved_OPD' and 'XMLDataMoved_PD' using the EXPORT utility.
The destination paths and base names of the exported XML files can be specified with the XML TO and XMLFILE
options. By default, exported XML files are written to the path of the exported data file. The default base name for
exported XML files is the name of the exported data file, with an appending 3-digit sequence number,
and the .xml extension.
The import utility is used to import XML data into an XML table column using either the table name or a nickname for a DB2 Database for Linux, UNIX, and Windows source data object. When importing data into an XML table column, you can use the XML FROM option to specify the paths of the input XML data file or files.