Although internally the XML is stored in a hierarchical format, logically in the database table it appears to be stored in a CLOB or BLOB.
尽管XML在内部存储为层次化格式,但逻辑上,在数据库表中,它似乎存储在CLOB或 BLOB中。
The larger messages should be read or received as CLOB.
更大的消息应该以CLOB的形式读取或接收。
Note that XQUERY, by default, serializes its result set into a CLOB.
注意,默认情况下,XQUERY会将它的结果串行化为一个CLOB。
Dynamic text elements are most often used to display CLOB data type values.
动态文本元素经常用来显示CLOB数据类型值。
Selecting an XML column from a table also serializes its result into a CLOB.
从一个表中选择一个xml列也会导致结果被串行化为一个CLOB。
A response message is returned as character LOB (CLOB) if issued by the server.
如果由服务器发出,则响应消息作为字符lob (CLOB)返回。
The parameter type used for XML documents in all the stored procedures is CLOB.
在所有存储过程中,用于XML文档的参数类型是CLOB。
Gone are the days of storing XML data as a CLOB or shredding to relational tables.
将XML数据存储为CLOB或将其分割为关系表的时代已经过去。
Indexed side tables are used to query the document that is retrieved as a CLOB.
使用带索引的副表查询文档,以clob形式获得文档。
Notice that the type of the message column to which the primitive logs is CLOB.
请注意,该原语记录的消息列的类型为CLOB。
The system generates a list of all of the CLOB fields found in the defect table (see table 2).
系统产生了所有clob字段的一个列表,这些字段列在defect表中(参见表2)。
CLOB is used to store Unicode character-based data, such as large documents in any character set.
CLOB用于存储基于Unicode的字符,例如使用任何字符集的大文档。
In the supplied samples, CLOB is used to pass the XML parameters to and from the stored procedures.
在提供的示例中,使用CLOB在存储过程传入和传出xml值。
The purchase order (Po) is stored as a CLOB in the relational database (as opposed to being shredded).
采购订单(PO)在关系数据库中存储为CLOB(而不分割)。
Smart large objects consist of character large object (CLOB) and binary large object (BLOB) data types.
智能大对象包括字符大对象(CLOB)和二进制大对象(BLOB)数据类型。
This table has a column that also contains the intact XML document, as a character large object (CLOB).
这个表中的一列还包含原样的XML文档,采用字符大对象(CLOB)形式。
The other common technique is to simply dump your XML document inside a CLOB column in the database.
另一种常见的技术是直接把XML文档转储到数据库的clob列中。
Side tables can avoid much of the XML parsing for CLOBs and can often make CLOB queries 100 times faster or more.
索引表能够避免许多针对 CLOB的XML解析,这通常能够使CLOB查询速度快 100倍或更多。
Storing the PO as a CLOB allows you to use the DOM in the application code to retrieve the relevant information.
将PO存储为CLOB,则可以在应用程序代码中使用DOM来检索相关信息。
The CLOB data type is defined as a character large object capable of storing characters up to 2,147,483,647 long.
CLOB数据类型定义为最多能够存储2,147,483,647个字符的字符大对象。
The result of the function is returned as a CLOB (Character Large Object) data type that can hold up to 1 MB of data.
函数的结果会以CLOB(字符型大型对象)数据类型的形式返回,可容纳1MB 的数据。
An easy way to identify this problem is to temporarily use CLOB types, which have no size restrictions, as target columns.
识别该问题的简易方法是临时使用clob类型作为目标列,它没有任何大小限制。
This overhead does not exist when reading full XML documents from a CLOB where the XML is already stored in text form.
当从CLOB(在clob中xml本来就是以文本形式存储的)读取完整的XML文档时,不存在此开销。
This articles USES CLOB in the supplied samples because it is easier to manipulate variables that are character-based in tools.
本文提供的示例使用CLOB,因为操纵基于字符的变量更容易。
Since logically the XML column appears the same as a VARCHAR, CLOB, or BLOB column, the INSERT statements are also similar.
因为从逻辑上看XML列与 VARCHAR、CLOB或BLOB 列相似,所以INSERT语句也是相似的。
Prior to the DB2 9 release, XML data was either stored intact as a character large object (CLOB) or shredded to relational tables.
在DB 29之前,XML数据要么作为字符大对象(CLOB)按原样存储,要么分解到关系表中。
Another case is when you want to store a document in a database as a string or a Character Large Object (CLOB) without parsing it.
另外一种情况是,不用解析文档,而将其作为字符串或字符大对象(Character Large Object,CLOB)存储在数据库中。
Only a blind full document retrieval, which again ignores the internal XML structure, can quickly read XML documents from CLOB columns.
只有盲目、全面的文档检索(这会再次忽略内部XML结构)能够快速从clob列读取XML文档。
This comparison is interesting because for a certain class of today's XML applications, CLOB columns are a commonly choice for XML storage.
这种比较是很有趣的,因为对于当今相当多的XML应用程序来说,clob列是XML存储最常用的选择。
All table Spaces were defined with the no file system caching option, except where otherwise noted (for some of the CLOB storage tests).
全部表空间均使用nofilesystemcaching选项定义,除非另外声明(用于某些clob存储测试)。
应用推荐