DB2 - 删除DATA CAPTURE字段的操作过程

最新推荐文章于 2023-09-05 17:34:53 发布

VIP文章 rcom10002

最新推荐文章于 2023-09-05 17:34:53 发布

阅读量3.4k

点赞数

分类专栏：数据库 - Database 文章标签： db2 table command access constraints query

本文链接：https://blog.csdn.net/rcom10002/article/details/6310308

版权

 [timetrac@viper01 ~]$ db2 alter table role data capture off
 DB21034E  The command was processed as an SQL statement because it was not a
 valid Command Line Processor command.  During SQL processing it returned:
 SQL0104N  An unexpected token "off" was found following "le role data
 capture".  Expected tokens may include:  "NONE".  SQLSTATE=42601
 [timetrac@viper01 ~]$ db2 alter table role data capture none
 DB20000I  The SQL command completed successfully.
 [timetrac@viper01 ~]$ db2 alter table role drop column active
 DB20000I  The SQL command completed successfully.
 [timetrac@viper01 ~]$ db2 alter table role data capture changes
 DB20000I  The SQL command completed successfully.
 [timetrac@viper01 ~]$ db2 values current schema

 1
 ------------------------------------------------------------------------------------------
 TIMETRAC

   1 record(s) selected.

 [timetrac@viper01 ~]$ db2 'select * from role where id = 0'

 ID     NAME                                     SHORTNAME                      DESCRIPTION
 ------ ---------------------------------------- ------------------------------ -----------
 SQL0668N  Operation not allowed for reason code "7" on table "TIMETRAC.ROLE".
 SQLSTATE=57016
 [timetrac@viper01 ~]$ db2 ? SQL0668N


 SQL0668N  Operation not allowed for reason code