Open topic with navigation

# InitialStatement

The query to send to the database to retrieve documents on the initial synchronize cycle (the full synchronize), when `UseIncrementalStatements=True`.

When `UseIncrementalStatements=True`, the connector uses this query to retrieve information from the database during the initial synchronize cycle. The following synchronize cycles use the query specified by AddedAndUpdatedStatement to retrieve added and updated documents, and the query specified by DeletedStatement to retrieve deleted documents.

When `UseIncrementalStatements=True` but you do not set this parameter, the connector uses query specified by `AddedAndUpdatedStatement` to retrieve documents during the initial synchronize cycle.

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

Type: | String
Default: |
Required: | No
Configuration Section: | TaskName or FetchTasks
Example: | `InitialStatement=SELECT * FROM table`
See Also: | UseIncrementalStatements AddedAndUpdatedStatement

© 2018 EntIT Software LLC, a Micro Focus company | Send documentation feedback to Micro Focus 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