GGSCI> DBLOGIN SOURCEDB srcdb USERID gg PASSWORD password
GGSCI> STOP *

GGSCI> INFO ALL
GGSCI> DELETE *
GGSCI> DELETE CHECKPOINTTABLE MDM_SAMPLE.GGS_EVENT_CHECKPOINT
GGSCI> DELETE CHECKPOINTTABLE MDM_SAMPLE.GGS_CHECKPOINT
GGSCI> STOP MGR
GGSCI> EXIT

 INSTALL.EXE DELETEEVENTS DELETESERVICE

--#SET TERMINATOR ~
CONNECT TO SRCDB USER gg USING password
~
SET SCHEMA MDM_SAMPLE
~
SET PATH MDM_SAMPLE, CURRENT PATH
~
SET SERVEROUTPUT ON
~
CALL DBMS_OUTPUT.ENABLE(1024000)
~
BEGIN
   DECLARE stmt VARCHAR(1000);
   FOR f1 AS c1 CURSOR WITH HOLD FOR 
       SELECT 
           TABSCHEMA,TABNAME,DATACAPTURE 
       FROM 
           SYSCAT.TABLES 
       WHERE 
           TABSCHEMA = CURRENT SCHEMA 
           AND TYPE = 'T' 
           AND DATACAPTURE <> 'N'
   DO
      SET stmt = 'ALTER TABLE '||TRIM(CURRENT SCHEMA)||'.'||f1.TABNAME||' DATA CAPTURE NONE';
      CALL DBMS_OUTPUT.PUT_LINE(stmt);
      COMMIT;
   END FOR;
END
~
COMMIT
~