Index extensions (user-defined structured type related).
索引扩展(与用户定义的结构化类型相关)。
A mutator method exists for each attribute of a structured type.
mutator方法是为某个结构化类型(structured type)的每个属性而存在的。
An observer method exists for each attribute of a structured type.
observer方法是为某个结构化类型的每个属性而存在的。
A typed table is a table that is defined with a user-defined structured type.
类型化表是一个使用用户定义的结构化类型定义的表。
In Listing 12 the operation takes a structured type as a single coarse-grained parameter.
而在清单12中的操作则采用结构化类型作为单个粗粒度参数。
The constructor function has the same name as the structured type with which it is associated.
构造函数和它关联的结构化类型有相同的名称。
In Listing 12 the operation takes a structured type as a single coarse -grained parameter.
而在清单12中的操作则采用结构化类型作为单个粗粒度参数。
As rows in a table (a typed table) whose columns are defined by the attributes of the structured type.
对于表(类型化表)中的行,其中的列是根据结构化类型的属性定义的。
We will need to create this structured type before we attempt to create the CLIENTS table (Listing 1).
在试图创建clients表(清单1)之前,需要创建这个结构化类型。
Use the create type statement to create a structured type, and use the DROP statement to delete a structured type.
可以使用CREATEtype语句创建一个结构化类型,并使用drop语句删除结构化类型。
If the column is a structured type column, you specify the name of the structured type as its data type (Listing 1).
如果列是结构化类型列,则需要将结构化类型的名称指定为其数据类型(清单1)。
Emp_t is the root type, and its definition happens to include the Address_t structured type that we created previously.
Emp_t是根类型,并且它的定义恰好包括我们先前创建的Address_t结构化类型。
In this case, the table is created with the structured type, and you don't specify individual columns in the table definition.
在这种情况下,表是用结构化类型创建的,并且您不必在表定义中指定单独的列。
For example, if we were to define a structured type called address_t, city might be one of the attributes of this structured type.
例如,如果我们定义了一个称为address_t的结构化类型,那么city可能就是这个结构化类型的一个属性。
To invoke a mutator or observer method on an instance of a structured type, use the double-dot (..) operator (Listings 1, 2, and 3).
为了在结构化类型的实例上调用mutator或observer方法,请使用双点(. .)运算符(清单1、清单2和清单3)。
A structured type can have subtypes, other structured types that reuse all of its attributes and contain their own specific attributes.
结构化类型可以包含子类型,以及重用其所有属性并包含自己的特定属性的其他结构化类型。
By default, the name of the casting function is the same as the name of the structured type (in this case, Engineer_t and Salesperson_t, respectively).
默认情况下,casting函数的名称和结构化类型的名称相同(在这里,这两个名称分别是Engineer_t和Salesperson_t)。
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.
REF USINGINTEGER子句指定了 INTEGER数据类型,将使用这个数据类型表示该结构化类型及其所有子类型的 REFERENCE 类型。
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).
为了实现这个目标,我们将调用observer方法(使用双点运算符)获取address列中的结构化类型值的城市属性。(清单2)。
When you create a structured type, DB2 automatically creates a constructor function for the type and creates both mutator and observer methods for the attributes of the type.
当您创建结构化类型时,DB 2为类型自动创建一个构造函数,并为类型的属性创建mutator方法和observer方法。
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.
每当尝试查询一个空间列时,DB 2加入一个转换,该转换将内部的、结构化类型的表示转换为应用程序能理解的表示。
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).
结构化数据类型可以用作普通表中某一列的类型(清单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).
结构化数据类型可以用作普通表中某一列的类型(清单1和清单2),也可以用作整个表(或视图)的类型,或者用作另一个结构化类型的属性(清单3)。
应用推荐