Open topic with navigation

# 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 2019 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