You can use its create table wizard, as shown in Figure 1.
可以使用它提供的创建表向导,如图 1 所示。
To illustrate the new DB2 9.5 XML update functionality, the sample table and data defined by the following CREATE TABLE and INSERT statements are used.
为了解释新的DB2 9.5XML更新功能,我们使用下面的CREATE TABLE和INSERT语句定义示例表和数据。
You can use the PASSTHRU session to directly send the create table statement to the data source and create a nickname for this new table.
您可以使用PASSTHRU会话直接将CREATE table语句发送到数据源,并为这个新表创建一个昵称。
A partitioning key is defined on a table with the CREATE table statement.
分区键是在一个表上用CREATE table语句定义的。
In a DPF environment, each table row is distributed to a database partition according to the distribution key specified in the CREATE table statement.
在DPF环境中,根据CREATE table语句中指定的分区键,表中的每个行被分布到一个分区上。
Tip: Named anchors are often used to create "table of contents" at the beginning of a large document.
命名锚一般用于在一个长篇幅文档中建立“内容小目录”。
You can also create your own conversion tables using the Create Table (CRTTBL) command.
您还可以使用Create Table(CRTTBL)命令创建自己的转换表。
The check constraints view allows you to create table check constraints for the table.
允许您为表创建表检查约束。
While the create table space operations are running, execute the following script from another session.
在执行创建表空间的操作时,从另一会话执行下列脚本。
The statement at D results in an error because the CREATE TABLE statement for the t1 table has been rolled back.
标签D的语句导致一个错误,因为t1表的CREATE TABLE 语句被执行了回滚。
After successfully converting from version 11.50.xc7 to 11.70.xc1, you can use the following command to create table with interval fragmentation.
成功地由版本11.50 .xC 7升级到11.70 .xC1之后,您可以使用以下命令,创建一个有区间存储残片的表格。
You define a partition key for a table on the CREATE TABLE statement.
要在CREATE TABLE语句中指定表的分区键。
For DDL, you will use generated db2ddl script to create table definitions.
对于ddl,使用生成的db2ddl脚本创建表定义。
The Check constraints view allows you to create table check constraints for the table.
Checkconstraints视图允许为表创建表检查约束。
The CREATE table statement now provides three ways to group data in a database table.
CREATE table语句现在提供了三种方式来组织数据库表中的数据。
Specify option 1 to ifx_grid_connect with the create table command to create the replicate on the table automatically.
要为ifx_grid_connect指定选项1,可以使用create table命令在表上自动创建副本。
Consider the simple example of two statements targeted for table T1 - CREATE table T1 (C1 INT).
考虑一个简单的例子,例子中有两个以表t 1为目标的语句——CREATE TABLET1 (C1INT)。
The result of the db2look call is a file sales.ddl containing the CREATE table statement for table sales.
db2look调用的结果是sales . ddl文件,其中包含sales表的CREATE table语句。
Running such a create table statement — by a user at the command line or by a custom application — creates these columns within each table.
用户在命令行上或通过定制应用程序运行这样的CREATE table语句将在每个表中创建这些列。
If a primary key is specified in the CREATE TABLE statement, the first column of the primary key is used as the distribution key.
如果在CREATE table语句中指定了一个主键,那么主键的首列会被用作分配键。
Once you have determined the MQT definitions, the MQTs can be created with the use of a " CREATE TABLE" statement.
一旦确定了MQT定义,就可以使用 "CREATE TABLE"语句创建MQT 了。
In this example, you see that the "Create table" statement failed to propagate on target servers.
在本例中,您将看到“Create table”语句未能广播到目标服务器。
Now, when creating partitioned tables, the partition boundaries are determined by the CREATE table statement instead of CREATE INDEX.
这时,当创建分区的表时,分区的边界由CREATE table语句决定,而不是由CREATEindex语句决定。
I also described two ways to use the partition BY clause of the create table statement to create partitioned tables.
我还描述了使用CREATE TABLE的PARTITIONBY子句来创建分区表的两种方法。
The dimensions are defined in the CREATE table statement and storage is reserved for each combination of values.
在CREATE table语句中定义维的时候,就为每种值的组合预留了存储空间。
Edit the generated SQL script adding the COMPRESS YES clause to the CREATE table statement for the noted fact tables.
编辑生成的sql脚本,对于标记的事实表添加COMPRESSyes子句到CREATE table语句。
If there is no partitioning key provided explicitly in the CREATE TABLE command, the following defaults are used.
如果在CREATE TABLE命令内没有显式地提供分区键,那么就会使用如下的这些默认值。
For the create table statement this is desirable.
对于create table语句而言,这是一种理想状况。
Notice in Listing 10, the SQL statement create table PURCHASE_ORDERS.
注意清单10中的sql语句create table PURCHASE_ORDERS。
To achieve this clustering, add the following clause to the second CREATE TABLE statement in Listing 3: ORGANIZE BY DIMENSIONS (label_comp_id).
为了实现这种集群,在清单3中的第二个CREATE table语句添加如下子句:organizeBYDIMENSIONS (label_comp _ id)。
应用推荐