To my knowledge, XML extender is the only way to go if you want to have
search capability on the content of the xml document.
There are 2 ways to use xml extender,
1. XML Columns - This means you store the xml as a clob in a table and you
have side tables that db2 maintains that exposes the xml data that you want
to search on.
2. XML collections - You supply the XML document and DB2 will break the
content down into relational tables (the mapping is described in a DAD file
(I think). When you extract the xml, DB2 will compose the XML from the same
relational tables using the map in the DAD file.
From my limited experience I have found xml columns to be inefficient. There
are xml extender functions to update the content on the xml document, but
these functions seem to delete the xml document, delete all the side table
rows (used for searching) ,then insert the row containing the xml clob and
then inserting the side table rows. This can be very expensive.
If you have a need to update the xml content, xml collections may be a
better solution.
-----Original Message-----
From: Oruganti Shaila
[mailto:db2udbdba-ezmlmshield-x52354237.[Email address protected]
Sent: Thursday, January 27, 2005 10:43 AM
To: LazyDBA Discussion
Subject: RE: Loading XML data to UDB tables on AIX/UNIX
Neil,
We do need to have querying ability on these tables. I was hoping if there
are utilities available that parse the XML data and schema to load the UDB
automatically. Is XML extender the only way to go and is this still a DB2
add-on-feature with V8.1?
Thanks
-----Original Message-----
From: Burrows Neil
[mailto:db2udbdba-ezmlmshield-x87873277.[Email address protected]
Sent: Thursday, January 27, 2005 12:27 PM
To: LazyDBA Discussion
Subject: RE: Loading XML data to UDB tables on AIX/UNIX
If you do not need to expose values in the xml documents to side tables
for seaching, then you do not need xml extender, you can put the xml
string into a clob.
-----Original Message-----
From: Oruganti Shaila [mailto:db2udbdba-ezmlmshield-x60546098.[Email
address protected]
Sent: Thursday, January 27, 2005 10:21 AM
To: LazyDBA Discussion
Subject: Loading XML data to UDB tables on AIX/UNIX
Hello!
One of my requirements needs XML data to be loaded to UDB tables on AIX
UNIX. I was wondering if there is any easier way to load XML data to
UDB tables. Any help or references on this would be greatly
appreciated.
Thanks, Voorkey
BTW, I'm a newbie here and recently completed my training on UDB DBA on
AIX and thought the forum was very interesting.
**** Important Notice to Recipients **** It is important that you do not
use e-mail to request, authorize or effect the purchase or sale of any
security or commodity, to send fund transfer instructions, or to effect
any other transactions. Any such request, orders, or instructions that
you send will not be accepted and will not be processed by Morgan
Stanley.
****************************************
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information in this electronic mail message is sender's business
Confidential and may be legally privileged. It is intended solely for
the addressee(s). Access to this Internet electronic mail message by
anyone else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or any action taken or omitted to be
taken in reliance on it is prohibited and may be unlawful.
The sender believes that this E-mail and any attachments were free of
any virus, worm, Trojan horse, and/or malicious code when sent. This
message and its attachments could have been infected during
transmission. By reading the message and opening any attachments, the
recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. Galileo International is not
liable for any loss or damage arising in any way from this message or
its attachments.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**** Important Notice to Recipients ****
It is important that you do not use e-mail to request, authorize or effect
the purchase or sale of any security or commodity, to send fund transfer
instructions, or to effect any other transactions. Any such request, orders,
or instructions that you send will not be accepted and will not be processed
by Morgan Stanley.
****************************************
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information in this electronic mail message is sender's business
Confidential and may be legally privileged. It is intended solely for the
addressee(s). Access to this Internet electronic mail message by anyone
else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or any action taken or omitted to be taken
in reliance on it is prohibited and may be unlawful.
The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading
the message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Galileo International is not liable for any loss or damage
arising in any way from this message or its attachments.
DB2 & UDB email list listserv db2-l LazyDBA home page