The
workbench can populate an XML column with data that is contained
in XML files. The XML files can be stored in the file system , or in
a data
development project.
The Insert into XML Column
wizard simplifies this process so that you can
insert XML data from multiple files at the same time. You can also
specify
an XML schema to validate the insertion.
The wizard creates
an INSERT statement and runs a batch insert
using the selected XML documents. If any of the documents fails the
insert,
the corresponding error message is displayed in the Data Output view
in the
Messages tab, and subsequent inserts on the remaining documents are
attempted.
Restriction: The Insert into XML Column
wizard performs an insert
into the selected XML column, and only that column. If any restriction
in
the database schema prevents the insert from occurring, for example,
if there
is another non-nullable column in the table that does not have a generated
value, then all of the inserts fail.