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.
您可以用同样方式使用结构化类型列创建表,也可以只使用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)。
DB2 LUW also stores table data on files, directories and raw devices depending upon the type of table space.
DB 2LUW还会根据表空间的类型将表数据存储到文件、目录和原始设备上。
The "Reorg recommended" column identifies the data type alterations that require table reorganization before a table can again be accessed (SQLSTATE 57016).
“需要重组”列表示这种数据类型修改是否要求在访问表之前进行表重组(SQLSTATE 57016)。
The ideal situation for base table row storage of XML data is when the table has only one column of XML type and the maximum size of the XML document doesn't exceed the page size.
使用XML数据基础表行存储的理想情形是,当表只有一个xml类型列并且XML文档的最大值没有超过页面大小时。
So far, you've learned how to design a table, including mapping out the table columns and defining the data type for each column.
目前为止,已经学习了如何设计表,包括规划表的列和定义每个列的数据类型。
Reserved extended table field: Pre-define a fixed number of additional data columns in each table with a generic column type (e.g. varchar).
保留的扩展表字段:在每个表中预先定义固定数量的额外数据列,这些列采用通用列类型(比如 varchar)。
Since the input data is being fetched from the User table in ADMINREG, you need a type tree that defines the data in that table.
由于输入数据从adminreg中的user表获取,因此需要一个定义该表中的数据的类型树。
A ROW type can be used to created type tables or as the data type for a column in a table. In the case of the zipcode_t type, it could be used in a table definition.
row类型可以用于已创建的类型表,或作为一个表中的一列的数据类型。
Comparisons are made on the features of the life table Method and the Product-Limit Estimation in life table constructing procedure. A special type of life data, the truncated data, is introduced.
对生命表法和乘积限估计法应用上的特点进行了比较,同时还对特殊的寿命数据类型——截断数据做了简要介绍。
Comparisons are made on the features of the life table Method and the Product-Limit Estimation in life table constructing procedure. A special type of life data, the truncated data, is introduced.
对生命表法和乘积限估计法应用上的特点进行了比较,同时还对特殊的寿命数据类型——截断数据做了简要介绍。
应用推荐