ODBC Connector 24.2

# PrimaryKeys

The column, or comma-separated list of columns, to use as the primary key for a table. The value in each row of the primary key column must be unique (the combination of values must be unique if you specify multiple columns). You must set this parameter so that the connector can determine whether rows are new, have been modified, or have been deleted.

The columns must be selected by the query specified by the `SQL` parameter (or `AddedAndUpdatedStatement` and `DeletedStatement` when `UseIncrementalStatements=true`).

NOTE: The value of this parameter is case-sensitive.

NOTE: You do not need to set the `PrimaryKeys` parameter for sub-tables.

Type: | String
Default: |
Required: | Yes
Configuration Section: | TaskName or FetchTasks
Example: | `PrimaryKeys=ColumnName` or `PrimaryKeys=ColumnName1,ColumnName2`
See Also: | SQL

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: PrimaryKeys