因为IXF格式没有用定界符分隔列和行,所以数据中可以使用任何字符。
Since IXF format does not require delimiters to separate columns and rows, any characters can be used in data.
在DB 2 9.7中,行压缩(也称为深度压缩)通过把跨行重复出现的值模式替换为更短的符号字符串来压缩数据行。
In DB2 9.7, row compression, also referred to as deep compression, compresses data rows by replacing patterns of values that repeat across rows with shorter symbol strings.
在处理字符串值时,向元素添加数据和将元素附加为行的子元素是非常直观的,如清单12所示。
Adding data to the element and appending the element as a child of the row is straightforward when working with string values, as in Listing 12.
分隔的ASCII (DEL)文件是ASCII字符流;数据流中的行由行分隔符分隔,而行中的列值由列分隔符分隔。
A delimited ASCII (del) file is a stream of ASCII characters; rows in the data stream are separated by row delimiters, and column values within a row are separated by column delimiters.
清单1的2 -8行示例代码展示了如何使用字符串url连接到外部安全数据源。
Lines 2-8 in listing 1 show a sample of code to connect to the external secure data source using string url.
第2行代码基于schema1中element0的定义和field0的内容创建了字符串数据元素。
Line 2 creates a string data element based on the definition for element0 in schema1 and the content of field0.
在本例中,可以向数据库添加三个字符串:feed项目的标题;描述;一般行,通知存在符合标准的feed项目。
In this case, three alternative strings could be added to the database: the title of the feed item, the description, or a generic line that says there is a feed item that fits the criterion.
注意:此查询的第一行调用XMLSerialize函数,这让DB2返回XML数据的序列化字符串版本。
Note: the first line of this query invokes the XMLSerialize function, which instructs DB2 to return a serialized string version of the XML data.
为每一行数据所创建的索引成为了计数器,因为每当新的一行数据加进来的时候,这个索引是唯一的增量,这也意味着计数器将与字符串数据的总量同步变化。
The index created for each row of data becomes the count because it was only incremented when a new row of data was found, meaning it is in sync with the amount of data in the string.
每一个集合中有h行数据,每一行有w个字符。
There are H more lines in the data set, each of which includes W characters.
具有讽刺意味的是,“字符串”26秒125行的表在数据库和数据库,需要0秒159行。
Ironically, the 'strings' table in database that takes 26 seconds has 125 rows and the database that takes 0 seconds has 159 rows.
具有讽刺意味的是,“字符串”26秒125行的表在数据库和数据库,需要0秒159行。
Ironically, the 'strings' table in database that takes 26 seconds has 125 rows and the database that takes 0 seconds has 159 rows.
应用推荐