Supported Characteristics

This section lists the supported characteristics of the Connector for ODBC.

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 Connectors LotusScript Extensions Guide for more information.

  • Writeback support -- Full except when the driver doesn't support ordered updatable cursors. In this case, writeback functionality is not available and is simulated with keyed operations. Make sure that the proper key settings and values are provided even when performing writeback update and remove operations.
  • Writeback index -- Index strongly advised, but not required. Use the command "create index <indexname> on <tablename> (<column1>, <column2>, ..., <columnN>)", or use the native system syntax if this is not supported. This is simulated by keyed operations for drivers which do not support cursors.
  • Statement syntax -- Level 1 ODBC SQL Syntax
  • Condition syntax -- Valid when placed in the following ODBC statement: SELECT ... WHERE <condition> ORDER BY ...
  • Array transfer -- None
  • Actions supported -- Clear, Reset, Truncate, Commit, Rollback
  • Catalog types -- Server (no connection required) Metadata, Field, Procedure, Parameter
  • Create types -- Metadata
  • Drop types -- Metadata

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