Supported characteristics of the Connector for Sybase

The following list captures supported characteristics of the Lotus® Connector for Sybase.

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 -- Full - see the Note that follows.
  • Writeback index -- Index required. Use the command "create unique index <indexname> on <tablename> (<column1>, <column2>, ..., <columnN>)"
  • Statement syntax -- Full Transact-SQL syntax, including stored procedures
  • Condition syntax -- Valid when placed in the following Sybase statement: SELECT ... WHERE <condition> ORDER BY ..
  • Array transfer -- None
  • Actions supported -- Clear, Reset, Truncate
  • Catalog types -- Database (no connection required), 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.

Note: Sybase requires a unique index on a table in order to create an updateable cursor against that table. If you set the writeback property of an LCConnection, issue a non-keyed select, and then receive an error, create a unique index against that table to enable the operation to complete successfully.