注意,不支持结构化数据类型。
结构化数据类型展示了一个称为继承的行为。
Structured data types exhibit a behavior known as inheritance.
这个页面将其称作一个类似于Python或Perl中的变量的结构化数据类型。
The page refers to it as a structured data type similar to variables in Python or Perl.
结构化数据类型是一种用户定义的数据类型,它包含了一系列的属性,每一个属性都有一个数据类型。
A structured data type is a form of user-defined data type that contains a sequence of attributes, each of which has a data type.
我们称其值由组成元素组成,且这些组成元素通过某种结构而彼此相关,类型结构为结构化数据类型或数据结构。
We will call any data type whose values are composed of component elements that are related by some structure a structured data type, or data structure.
结构化数据类型可以用作普通表中某一列的类型(清单1和清单2),也可以用作整个表(或视图)的类型,或者用作另一个结构化类型的属性(清单3)。
A structured data type can be used as the type for a column in a regular table (Listings 1 and 2), the type for an entire table (or view), or as an attribute of another structured type (Listing 3).
您可以用同样方式使用结构化类型列创建表,也可以只使用DB 2内置数据类型创建一个表。
You can create a table with structured type columns in the same way that you would create a table using only DB2 built-in data types.
如果列是结构化类型列,则需要将结构化类型的名称指定为其数据类型(清单1)。
If the column is a structured type column, you specify the name of the structured type as its data type (Listing 1).
对于一个或多个列中的值,可以使用结构化类型作为数据类型对它们进行定义。
As values in one or more columns, which are defined using the structured types as their data types.
FROMsql子句定义了特定的函数,可以使用该函数将将一个值转换成表示结构化类型的内置数据类型。
The FROM SQL clause defines the specific function that will be used to transform a value to a built-in data type value representing the structured type.
为了从表中检索结构化类型数据,必须有一些将类型转换成一个标量值,换句话说,这些值的类型必须基于某种内置的DB2 数据类型。
To retrieve structured type data from a table, there must be some way to convert that type into a single scalar value whose type, in turn, must be based on one of the built-in DB2 data types.
公司还可能需要分析半结构化文本(比如XML内容)或其他数据类型(比如音频和视频)。
Companies may also have a need to analyze semi-structured text (such as XML content) or other data types (such as audio and video).
REF USINGINTEGER子句指定了 INTEGER 数据类型,将使用这个数据类型表示该结构化类型及其所有子类型的 REFERENCE 类型。
The REF USING INTEGER clause specifies that the INTEGER data type will be used to represent the REFERENCE type of this structured type and all of its subtypes.
为了表示一个抽象数据缓冲区,需要声明两个结构化的数据类型。
To represent an abstract data buffer, declare two structured data types.
数据类型分两种,一种是非结构化数据,比如文档和图片,另一种是结构化数据,比如数据库中的数据。
There are two types of data, one is unstructured data, such as documents and pictures, and the other is structured data, such as data in the database.
数据类型分两种,一种是非结构化数据,比如文档和图片,另一种是结构化数据,比如数据库中的数据。
There are two types of data, one is unstructured data, such as documents and pictures, and the other is structured data, such as data in the database.
应用推荐