Supported characteristics of the Connector for OLE DB

The following table captures supported characteristics of the Lotus® Connector for OLE DB.

For a definition of the terms used in this section, see "Supported Connector Characteristics -- List of Terms" in Chapter 3 of this manual. If you are accessing the connector using LotusScript®, see the Lotus® Connector LotusScript® Extensions Guide for more information.

• Writeback support -- Depending on the OLE DB provider, writeback support is not always available. If it is not available, it will be simulated by the Lotus® Connector for OLE DB using keyed operations. Make sure that the proper key settings and values are provided even when performing writeback update and remove operations.
• Writeback index -- Index required for SQL server. Use the command "create index <indexname> on <tablename> (<column1>, <column2>, ..., <columnN>)".
• Statement syntax -- Dependent on the OLE DB Provider. For Microsoft™ SQL server Full Transact-SQL syntax is supported, including stored procedures.
• Condition syntax -- Valid when placed in the following SQL statement: SELECT ... WHERE <condition> ORDER BY
• Array transfer -- None
• Actions supported -- Clear, Reset, Truncate, Commit, Rollback
• Catalog types -- Database, Metadata, Index, Field, Procedure, Parameter
• Create types -- Metadata, Index
• Drop types -- Metadata, Index

All connections have a set of properties with values that can be assigned and retrieved. See the Lotus® Connector LotusScript® Extensions Guide for a list of supported properties for each Connector. Also see the "Common Connector Properties" and "LCConnection Properties" sections in the LCConnection Class chapter of that same manual.