ODBC Connector 24.2

# 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 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: InitialStatement