Hi Phil,
Don't know if 32k is long enough for you, but we were able to get away with
just using normal data types such as varchar(32000). These seem to work
just as well as the XML data types. There probably is some difference
under the covers, but for XML generation and for inserting a whole XML doc
into a single column for subsequent use of XPath to perform updates and
deletes via XML, they work fine. So if 32k will suffice, just use
varchar(32000).
HTH,
Jay
Jay Reavill
[EMAIL PROTECTED]
IBM Global Services
Tampa, Florida
Tel: (813) 356-5317, Tie Line 8-697-5317
-----------------------------------------------------
Happiness is not around the corner.
Happiness is the Contour (SVT) of the road.
-----------------------------------------------------
The early bird gets the worm,
but the second mouse gets the cheese.
-----------------------------------------------------
Philip Nelson
<[EMAIL PROTECTED] To: DB2EUG <[EMAIL PROTECTED]>,
DB2-L
om> <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: [DB2EUG] Logging XMLCLOBs
ash.org
10/02/2003 08:55
AM
Please respond to
Philip Nelson
Guys,
The next thing I've come across while working with the XML Extender is
that the XMLCLOB data type is defined as maximum size 2 gig. The
maximum loggable size of a column is 1 gig.
XMLVARCHAR is 3k (too short for our purposes).
We want to take advantage of the XML Extender functionality but also
want to log the column. In general we reckon the documents will be less
than 100k.
I was wondering about defining another UDT under the DB2XML schema, with
a maximum size of 1 gig. Is this possible (or is DB2XML reserved ).
And what do I need to do to allow the existing XML UDFs and SPs to act
on the new column type.
TIA
Phil
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
