ODBC Connector 26.1
ODBC Connector Help

# AddedAndUpdatedStatement

The SQL statement to use to find new and updated 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: | `AddedAndUpdatedStatement=select * from table where lastmodified > '@lastruntime'`
See Also: | InitialStatement DeletedStatement LastRunTimeFormat UseIncrementalStatements

Copyright 2025 Open Text
Version 26.1 | Last updated January 2026

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 MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: Knowledge Discovery ODBC Connector 26.1

Topic Title: AddedAndUpdatedStatement