例如,如果COL1是一个长度为1的字符列,像COL1BETWEEN'2 'AND '4 '的一个谓词可能被重写为COL1IN (' 2 ','3 ',' 4 ')。
For example, if COL1 is a character column of length one, a predicate like COL1 BETWEEN '2' AND '4' could be rewritten as COL1 IN (' 2 ', '3', '4').
一些应用程序创建只包含字符数据类型的列的表。
Some applications create tables with columns of character data type only.
因为IXF格式没有用定界符分隔列和行,所以数据中可以使用任何字符。
Since IXF format does not require delimiters to separate columns and rows, any characters can be used in data.
这个表中的一列还包含原样的XML文档,采用字符大对象(CLOB)形式。
This table has a column that also contains the intact XML document, as a character large object (CLOB).
因为计算过的表达式可能很长,并且可能包含对于XML标记来说非法的字符,所以计算过的列仅由它们的位置命名。
Since a calculated expression can be long, and contain characters illegal for XML tags, calculated columns are named simply by their position.
然而,如果列是字符数据类型,并且只包含数字字符,那么可以通过将NUMERIC_STRING选项设置为“Y”来表明这一点。
However, if the column is a character data type and contains only numeric characters, you can indicate this by setting the NUMERIC_STRING option to 'y.'
包含客户类型作为字符的列。
将Valuetab添加到您的注释中,还要添加一列以管道字符(|)分隔并终止的数据元素,如图6所示。
Add a Value Tab to your annotation, along with a list of data elements, separated by and terminated with a pipe character (|), as in Figure 6.
字符和图形的Perl用户界面列在CPAN上。
Character and graphical Perl user interfaces are listed on CPAN.
例如,数据库中的name列现在是100个字符长。
For example, the name column in the database is now 100 characters long.
包含客户国籍作为字符的列。
A column that contains the country of the customer as characters.
也就是说,它将从紧挨着游标的上一行中复制同一列中的字符。
That is, it copies the character in the same column from the line immediately above the cursor. For example, a CTRL-Y in the following situation would insert an "m" at the cursor.
清单1说明如何使用这些存储过程来生成每行的xml元素字符串,每个字符串包含每列的一个元素。
Listing 1 demonstrates how to use these stored procedures to produce one XML element string per row, each containing one element per column.
这样,我可以让它们作为散列的键、将要被检索的字符串列表,等等。
Thus, I can use them as hash keys, lists of strings to be searched, etc.
如果字符串和列都不应该为空,那么就请确保正确编写了迁移。
If you have strings and columns that should not be null, make sure you code your migration appropriately.
如果将字符串存储在DB 2数据库的VARCHAR或char类型的列中,那么就常常需要在这些字符串上应用基于内容的谓词。
If you store strings in columns of type VARCHAR or CHAR in a DB2 database, you often have the need to apply content-based predicates on those strings.
由于不同的书籍可能用不同的语言编写,因此需要在同一个DB 2列中存储包含不同字符集的XML文档。
Because different books may be written in different languages, you may need to store XML documents containing different character sets in the same DB2 column.
因为图形化字符总是2字节长的,所以可以建立索引的最大图形化字符长度是510个字符,列可以定义为VARGRAPHIC (510)。
Since a graphic character is always 2 bytes long, the maximum graphic length that can be indexed is 510 graphic characters, and the column can be defined as VARGRAPHIC (510).
报表属性文件包含文本的字符串定义,包括报表标题、描述以及列标题。
The report properties file contains text string definitions that include report titles, descriptions, and column headings.
我们稍后将使用这个散列把词转换为等效的语音字母字符串。
We'll use this hash later to change words into a string of their phonetic alphabet equivalents.
对于多列页面,平均在40至50个字符每行最好。
For multiple column work, a better average is 40 to 50 characters.
该索引包含实际字符串的散列值,只能用于等式谓词,不能用于范围谓词。
This index contains hash values of the actual strings and can be used for equality predicates only, not for range predicates.
因此,如果想定义一个最多存储10个字符的varchar列,那么必须将这个列定义为VARCHAR(40),因为一个字符占用1到4字节。
Hence, if you want to define a VARCHAR column that can store up to 10 characters, you have to define the column as VARCHAR (40) because a single character requires from 1 to 4 bytes.
比这稍大一点的字符串存储到适当的行和列时会被截断。
A bite string larger that this will be truncated when stored in the appropriate row and column.
因此,如果涉及非ascii字符,那么列中可以存储的最大字符数可能会减少。
Therefore, the maximum number of characters that can be stored in the column might be reduced if non-ASCII characters are involved.
例如,如果需要忽略第一列中的字符串,则使用2:3进行绘图。
For instance, if you have a string in the first column that you need to ignore, plot using 2:3 instead.
TRUNCATED-当列值超过列的宽度时,截断超出的字符。
TRUNCATED - When the column value exceeds the column width, truncate the exceeding characters.
通常 RFC_READ_TABLE返回一个表,包含所有希望提取的列(作为字符串给出)。
Normally, RFC_READ_TABLE returns a table with all the columns that you want to fetch printed to a string.
可在字符串中使用伪列LEVEL,使分层结构变得可视。
The pseudo column LEVEL is used in a string to make the hierarchy visible.
可在字符串中使用伪列LEVEL,使分层结构变得可视。
The pseudo column LEVEL is used in a string to make the hierarchy visible.
应用推荐