Open topic with navigation

# DeletedStatement

The SQL statement to use to find deleted records when `UseIncrementalStatements=True`.

When `UseIncrementalStatements=True`, the connector runs the queries specified by `InititalStatement`, `AddedAndUpdatedStatement` and `DeletedStatement` instead of the query specified by the `SQL` parameter.

When `UseIncrementalStatements=False`, this parameter is ignored.

The string `@lastruntime` is replaced with the time of the last successful synchronize. The last run time is stored using GMT. If the dates in the database table differ from GMT, you can use the `DATE_SUB()` and `DATE_ADD()` functions to modify the last run time as required.

Type: | String
Default: |
Required: | No
Configuration Section: | TaskName or FetchTasks
Example: | `DeletedStatement=select * from table where deleted=1`
See Also: | InitialStatement AddedAndUpdatedStatement LastRunTimeFormat UseIncrementalStatements

© Copyright 2018 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm