Supported characteristics for the Connector for DB2®

This section describes LotusScript® functionality available for the Connector for DB2®.

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 Connector LotusScript® Extensions Guide for a detailed description of the LotusScript® properties and methods supported by the Connector for DB2®.

Note: The Connector for DB2® provides the standard set of Connector methods, or function calls, to control interaction with a DB2® connection. All methods are supported. However, certain methods only support a subset of functions. Unsupported functions will return the following error message:

"Requested functionality is not available."

  • Connection properties -- Database, UserID, and Password
  • Standard functionality -- Full
  • Writeback support -- Full except when the result set is ordered. 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>)". (Simulated by keyed operations when cursors are not supported.)
  • Statement syntax -- Full DB2® SQL Syntax, including UDFs (User Defined Functions)
  • Condition syntax -- Valid when placed in the following DB2® statement: 
    SELECT ... WHERE <condition> ORDER BY ...
  • Array transfer -- Insert
  • Actions supported -- Clear, Reset, Truncate, Commit, Rollback
  • Catalog types -- Database (no connection required), Metadata, 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 Connector LotusScript® Extensions Guide for a list of supported properties for this Connector. Also see sections "Common Connector Properties" and "LCConnection Properties" in the LCConnection Class chapter of that same manual.