[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
DB2 - 删除DATA CAPTURE字段的操作过程
最新推荐文章于 2023-09-05 17:34:53 发布
本文档详细记录了在DB2数据库中如何通过命令行处理器执行删除数据捕获字段以及解决SQL0668N错误的操作步骤,包括ALTER TABLE命令的使用以及在遇到表格限制时的解决策略。
摘要由CSDN通过智能技术生成