Is there any way to debug the issues during IMPORT?
s.piyush58 0 Newbie Poster
mallar6 0 Light Poster
It is better you to include a message in any import. It writes the messages to the file specified, then you can debug from the message file. This is a easier way to rectify the problems quickly. You can check http://www.ibm.com/developerworks/db2/library/techarticle/dm-0610tham/#listing5 for more information on this.
apuri976 0 Newbie Poster
Can I validate the XML document against a XML schema?
mallar6 0 Light Poster
DB2 9 can validate the XML document at the time of import against a registered XML schema. To validate your XML data when importing into DB2 relational table, in addition to a data file, you also require an XML schema to be used for validation.
s.piyush58 0 Newbie Poster
Can I import an XML document to DB2 9 without validation?
mallar6 0 Light Poster
You can import XML data into a DB2 table with XML data type column with or without validation. You can always choose not to validate the XML data at the time of import.
s.piyush58 0 Newbie Poster
How do I validate the XML document?
mallar6 0 Light Poster
The XMLVALIDATE function can be used to validate an XML document. Using this function on the XML document ensures that insert or update happens only if the validation is successful.
apuri976 0 Newbie Poster
I have a few huge XML documents. It fails to get opened in most of the external tools. Can pureXML handle this?
mallar6 0 Light Poster
pureXML can handle huge XML documents. It can handle XML documents up to 2 GB. For those which are greater than 2 GB, you can split into smaller documents.
s.piyush58 0 Newbie Poster
How do you split a large XML document using pureXML?
mallar6 0 Light Poster
This can be done using XML table. More information can be found at http://www.ibm.com/developerworks/db2/library/techarticle/dm-0709nicola/
s.piyush58 0 Newbie Poster
What kind of XML schema support is available in pureXML?
mallar6 0 Light Poster
pureXMl supports flexible schema where there is no need for a fixed schema per XML column. You can use 0 or 1 or more schemas per XML column. Even if these schemas are conflicting for different columns, you can still use these schemas within an XML column.
apuri976 0 Newbie Poster
How to check the information about the XML schemas in the XSR?
mallar6 0 Light Poster
Check the XML Schema thread under XML. Your query ia answered there.
apuri976 0 Newbie Poster
I have a few huge XML documents. It fails to get opened in most of the external tools. Can pureXML handle this?
mallar6 0 Light Poster
pureXML can handle huge XML documents. It can handle XML documents up to 2 GB. For those which are greater than 2 GB, you can split into smaller documents.
apuri976 0 Newbie Poster
Hey Guys check it out..
IBM Migration ToolKit (MTK) can be downloaded at
http://www-306.ibm.com/software/data/db2/migration/mtk/. More information can be found at
http://www-1.ibm.com/support/docview.wss?rs=203&uid=swg27009230.
apuri976 0 Newbie Poster
I want to create index on XML column. Is there any way to create index on XML columns of DB2 9?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.