IBM InfoSphere CDC lets you execute SQL statements after it applies a table-level clear or refresh operation to a target table. You can specify SQL statements in the Additional SQL dialog box in Management Console. By default, this feature is disabled in IBM InfoSphere CDC for security reasons. You can enable this feature by creating a table called TS_SQL_EXECAUTH in the database where you installed IBM InfoSphere CDC. The structure of the table is unimportant, and you must create the table using the same schema as the metadata tables during the configuration of IBM InfoSphere CDC. For more information about specifying SQL statements in Management Console, see “Specifying SQL to control refresh operations” in your Management Console documentation.
To enable SQL statements in Management Console Procedure
1 Locate the database on the target server that you created for IBM InfoSphere CDC. Depending on how you are using IBM InfoSphere CDC, this is the database you want IBM InfoSphere CDC to replicate to or from.
During installation, IBM InfoSphere CDC places metadata tables in the database necessary for IBM InfoSphere CDC processes.
2 If you want to enable the specification of SQL statements, create a table named TS_SQL_EXECAUTH in the database.
The table can have any structure and must be created in the schema you specified when you configured IBM InfoSphere CDC.