Oracle Connector 12.13

# DeleteEventSQL

The SQL query to use to delete rows from the event table after they have been ingested.

You can use the placeholder `@Clause` in the query. The connector replaces this with a clause that identifies the rows that have been ingested.

When you set this parameter, the connector operates in event-table mode. On each synchronize cycle, the connector runs the query specified by the SQL parameter to extract information from the table and processes it according to the value of EventTableType. It then uses the query specified by this parameter to delete the rows that it has processed.

Type: | String
Default: |
Required: | Required to retrieve information from an event table, otherwise not required
Configuration Section: | TaskName or FetchTasks
Example: | `DeleteEventSQL=DELETE FROM eventtable WHERE @Clause`
See Also: | SQL

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.13 | Last updated October 2022

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL Oracle Connector 12.13

Topic Title: DeleteEventSQL