ODBC Connector 25.4
ODBC Connector Help

# 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 2025 Open Text
Version 25.4 | Last updated October 2025

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: Knowledge Discovery ODBC Connector 25.4

Topic Title: InitialStatement