Oracle Connector 24.3

# SQL

The `SQL` parameter specifies the query sent to the database. The rows returned by the query are transformed into documents.

If you are writing a SQL command to extract data from a sub-table, you can use the @ character to substitute data from the main table. For example:

    [Example]
    ConnectionString=...
    SQL=select * from orders
    PrimaryKeys=OrderID
    Template=C:\Autonomy\OracleConnectorCFS\template.tmpl
    SubTables=Customers

    [Customers]
    Template=C:\Autonomy\OracleConnectorCFS\customers.tmpl
    SQL=select * from Customers where CustomerID=@CustomerID

The connector runs the sub-table query for every row that is retrieved from the main table. In this example, the connector replaces`@CustomerID` with the value of the `CustomerID` column from the main (`orders`) table.

NOTE: If you want the connector to report the progress of synchronize tasks, the value of the `SQL` parameter (for the main table) must not include an ORDER BY clause.

Type: | String
Default: |
Required: | Yes
Configuration Section: | Any section named by SubTables, or TaskName or FetchTasks
Example: | `SQL=SELECT * FROM table`
See Also: | AddedAndUpdatedStatement DeletedStatement UseIncrementalStatements

Copyright 2024 Open Text
Version 24.3 | Last updated June 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 Oracle Connector 24.3

Topic Title: SQL