Oracle Connector 12.13

# 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

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.13 | Last updated October 2022

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

We appreciate your feedback!

Product: IDOL Oracle Connector 12.13

Topic Title: InitialStatement