用户定义的结构化类型及其转换函数。
User-defined structured types and their transform functions.
构造函数和它关联的结构化类型有相同的名称。
The constructor function has the same name as the structured type with which it is associated.
索引扩展(与用户定义的结构化类型相关)。
最常见的情况是，结构化类型被存储到数据库中。
常用的两个子类型是结构化类型和行为或操作类型。
Two commonly used subtypes are: Structural types and Behavioral or Operational types.
而在清单12中的操作则采用结构化类型作为单个粗粒度参数。
In Listing 12 the operation takes a structured type as a single coarse-grained parameter.
类型化表是一个使用用户定义的结构化类型定义的表。
A typed table is a table that is defined with a user-defined structured type.
observer方法是为某个结构化类型的每个属性而存在的。
An observer method exists for each attribute of a structured type.
在试图创建clients表(清单1)之前，需要创建这个结构化类型。
We will need to create this structured type before we attempt to create the CLIENTS table (Listing 1).
而在清单12中的操作则采用结构化类型作为单个粗粒度参数。
In Listing 12 the operation takes a structured type as a single coarse -grained parameter.
在这种情况下，表是用结构化类型创建的，并且您不必在表定义中指定单独的列。
In this case, the table is created with the structured type, and you don't specify individual columns in the table definition.
对于表(类型化表)中的行，其中的列是根据结构化类型的属性定义的。
As rows in a table (a typed table) whose columns are defined by the attributes of the structured type.
对于一个或多个列中的值，可以使用结构化类型作为数据类型对它们进行定义。
As values in one or more columns, which are defined using the structured types as their 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).
已经创建了所需的结构化类型，现在我们就可以创建基于这些类型(清单3)的类型化表。
Having created the necessary structured types, we can now create typed tables that are based on these types (Listing 3).
结构化类型可以包含子类型，以及重用其所有属性并包含自己的特定属性的其他结构化类型。
A structured type can have subtypes, other structured types that reuse all of its attributes and contain their own specific attributes.
mutator方法是为某个结构化类型(structured type)的每个属性而存在的。
A mutator method exists for each attribute of a structured type.
您可以用同样方式使用结构化类型列创建表，也可以只使用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.
Emp_t是根类型，并且它的定义恰好包括我们先前创建的Address_t结构化类型。
Emp_t is the root type, and its definition happens to include the Address_t structured type that we created previously.
可以使用CREATEtype语句创建一个结构化类型，并使用drop语句删除结构化类型。
Use the create type statement to create a structured type, and use the DROP statement to delete a structured type.
这种非结构化类型的数据的增长势头有增无减，因此高效地处理它对于商业分析处理系统的持续成功至关重要。
This type of unstructured data continues to grow unabated, making the efficient processing of it critical to the continued success of business analytic processing systems.
如果DB 2 _ PROGRAM还没有对结构化类型进行定义，那么您可以为结构化类型创建组。
If DB2_PROGRAM has not already been defined for the structured type, you can create that group for your structured type.
对于DB 2索引扩展要注意的一点是对用户定义类型的需求—distinct类型或结构化类型。
One thing to be aware of regarding DB2 index extensions is the requirement for user-defined types - either distinct types or structured types.
一个有益的习惯是，使用' _ t '后缀来命名结构化类型，使它们的结构化类型特征变得更明显。
A useful convention is to name structured types with the '_t' suffix to make their identity as structured types obvious.
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.
每当尝试查询一个空间列时，DB 2加入一个转换，该转换将内部的、结构化类型的表示转换为应用程序能理解的表示。
Whenever you try to query a spatial column, DB2 injects a transformation from the internal, structured type representation to a representation that can be understood by the application.
例如，如果我们定义了一个称为address_t的结构化类型，那么city可能就是这个结构化类型的一个属性。
For example, if we were to define a structured type called address_t, city might be one of the attributes of this structured type.
当您在结构化类型的实例上调用observer方法并为其相关联的属性指定一个新值时，该方法将返回这个实例的一个属性值。
When you invoke an observer method on an instance of a structured type, the method returns the value of the attribute for that instance.
为了在结构化类型的实例上调用mutator或observer方法，请使用双点(. .)运算符(清单1、清单2和清单3)。
To invoke a mutator or observer method on an instance of a structured type, use the double-dot (..) operator (Listings 1, 2, and 3).
为了实现这个目标，我们将调用observer方法(使用双点运算符)获取address列中的结构化类型值的城市属性。(清单2)。
To do that, we will invoke the observer method (using the double-dot operator) for the city attribute of the structured type value in the ADDRESS column (Listing 2).
应用推荐