ODBC Connector 24.2

# UseIncrementalStatements

The `UseIncrementalStatements` parameter specifies whether to run queries that identify new/updated and deleted records.

- When `UseIncrementalStatements=False`, the connector performs a full synchronize every time the task runs, using the query specified by the SQL parameter.

- When `UseIncrementalStatements=True`, the connector only performs a full synchronize the first time the synchronize task runs:

  - The first synchronize cycle runs the query specified by the InitialStatement parameter. If this parameter is not set, the connector runs the query specified by AddedAndUpdatedStatement.
  - The following synchronize cycles run the query specified by AddedAndUpdatedStatement to retrieve added and updated documents, and the query specified by DeletedStatement to retrieve deleted documents.

Using incremental mode can be more efficient if the database has items stored by modified date, because the connector doesn't need to rescan the entire database.

Type: | Boolean
Default: | False
Required: | No
Configuration Section: | TaskName or FetchTasks
Example: | `UseIncrementalStatements=True`
See Also: | InitialStatement AddedAndUpdatedStatement DeletedStatement

Copyright 2024 Open Text
Version 24.2 | Last updated March 2024

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: IDOL ODBC Connector 24.2

Topic Title: UseIncrementalStatements