修改复制表。
If you attempt to alter a table to use this lock size option, and it isn't an MDC table, you will receive an SQLSTATE 628n error.
如果您尝试修改一个表,以便使用这种锁粒度选项,而那个表又不是mdc表,那么您将收到一个SQLSTATE 628n错误。
Alter the locking granularity of a table.
改变表的锁定粒度。
In addition, you can alter the table definition.
此外,还可以改变表定义。
Alternatively, you can alter a table to enable compression, and then you can reorganize it to compress the data.
还可以为现有的表启用压缩,然后可以重组它以便压缩数据。
This can be added to existing tables using the ALTER table statement, or the row change timestamp column can defined when creating a new table.
这可以通过ALTER table语句添加到现有表,或者在创建新表时定义行修改时间戳列。
A new, empty partition can be added to a partitioned table by executing the ALTER TABLE statement with the ADD PARTITION option specified; the syntax used looks like this
可以通过执行ALTER TABLE语句并指定ADDPARTITION选项来向一个分区表增加一个新的空分区,使用的语法如下所示
You cannot alter the external table schema.
不能改变外部表模式。
You can alter a replicated table in any of the following ways.
可以通过以下方式改变复制的表。
If the synchronization status is "same as db", alter the table using the DB2cmd SQL editor. For example.
如果同步状态是“sameasdb”,使用db 2cmdSQL编辑器改变此表,例如。
You can create a table WITH AUDIT clause or alter table ADD|DROP AUDIT clause.
您可以创建一个表格WITHAUDIT 子句,或者改变表格ADD|DROP AUDIT 子句。
You can easily attach and detach the partitions using the DB2 alter table command to move the data from one table (production table) to another table (history table) in the same database.
您可以很容易使用DB 2alter table命令来附加和分离分区,从而将数据从一个表(生产表)移动到同一个数据库的另一个表(历史表)中。
The following example demonstrates how to rename a column using the ALTER table command while keeping the table fully accessible.
下面的示例演示了如何使用ALTER TABLE命令重命名一个列,同时保持表具有完整的可访问性?
The second algorithm is used when the table is placed in APPEND mode through ALTER table.
当表是通过ALTER table以append模式放置时,就要使用第二种算法。
Thus, if you wanted to add an empty partition to a partitioned table named SALES, you could do so by executing an ALTER table statement similar to this.
这样,如果您想添加一个分区表名为SALES的空分区,可以执行一个与下面类似的ALTER table语句。
In combination with enhancements to the ALTER TABLE statement, a convenient way for managing different versions of a database solution was created.
再结合使用对ALTER table语句的改进,就可以方便地管理数据库解决方案的不同版本。
It needs enough space to perform the alter operation on the associated delete table, along with the alter operation on the replicated table.
它需要足够的空间来执行对相关的删除表的alter操作,以及对复制表的alter操作。
There are two ways to alter a replication table.
有两种方法可以用来修改复制表。
Some operations like ALTER table require no cursor to be open, while others like CREATE INDEX ONLINE allow cursors on the table.
ALTER TABLE等一些操作要求不打开游标,而CREATEINDEXONLINE等其它操作则允许表上的游标。
When there are no dependent materialized query tables (MQT), the system initiates the second phase after the first phase (ALTER table DETACH PARTITION) commits.
当不存在依赖的物化查询表(MQT)时,系统在完成第一阶段(ALTER TABLEDETACHPARTITION)的提交后,启动第二阶段。
The script below will scan for AW fact tables named using the wildcard expression % _measures and scripts ALTER table and REORG commands.
以下脚本将使用通配符表达式% _ MEASURES以及脚本alter TABLE和REORG命令扫描指定的aw事实表。
You can enable versioning of the temporal table by using the ALTER table command with the ADD versioning clause and specifying the history table name in the use history table clause (see Listing 3).
您可以使用ALTER TABLE命令和ADDversioning子句,并在USEHISTORY table子句中指定历史表名称,为时态表启用版本控制(参见清单3)。
Use the cdr alter --on command to place the replicated table in alter mode.
使用cdralter --on命令使复制表处于 alter模式。
Before attaching fragments place the table in alter mode.
附加片段之前,要先将表置于alter模式之下。
The ALTER COLUMN SET DATA type option on the ALTER TABLE statement has been extended to support all compatible types.
ALTER table语句中的ALTERCOLUMNSETDATATYPE选项进行了扩展,可以支持所有兼容的类型。
In conversions to DB2 9.1, the ALTER TABLE statement with data compression is supported, and limited support is provided for CREATE TABLE statement.
在到DB 2 9.1的转换中,包含数据压缩的ALTER table语句是受支持的,CREATE table语句也受到有限的支持。
Using the grid, you just need to execute the alter table SQL statement on the server where you have enabled the grid.
使用网格,您只需在启用了网格的服务器上执行SQL命令alter table。
You can use ALTER TABLE with the DROP VERSIONING clause for the same purpose, but IBM suggests sparse use of DROP VERSIONING because it can cause invalidation, which should be avoided if possible.
您可以使用ALTER TABLE和DROPversioning子句实现相同用途,但IBM建议尽量少使用DROP VERSIONING,因为它可能导致无效性,这应该尽可能避免。
SQL described tables and indexes can also be placed and moved by the corresponding ALTER TABLE or ALTER INDEX commands.
SQL描述的表和索引也可以通过对应的ALTER TABLE或 ALTERINDEX命令放置和移动。
You can also run other types of SQL statements, such as ALTER TABLE statements, using the ActiveRecord: : Base.connection.execute method, as shown in Listing 14.
您还可以使用ActiveRecord:Base . connection . execute方法运行其他类型的sql语句,比如alter table语句,如清单14所示。
应用推荐