DB2® Connector Properties

This table defines the properties for the Lotus® Connector for DB2®.

Property Token

Property Name/Description

Type

Example

LCTOKEN_DATABASE

Database

Specifies the DB2® database name used to establish a connection. Required.

Text

"db2verx"

LCTOKEN_ USERID

Userid

Specifies the user name as known by DB2®. This user name is used to authorize access to the specified database.

Required.

Text

"db2inst1"

LCTOKEN_ PASSWORD

Password

Specifies a password associated with the specified user name known by DB2®.

Required.

Text

"dbinstpass"

LCTOKEN_ METADATA

Metadata

Specifies the name of a DB2® table to access during an operation.

Text

"DBINST1.EMP_TABLE"

LCTOKEN_ INDEX

Index

Specifies the name of a DB2® index.

Text

"DBINST1.EMPID"

LCTOKEN_ MAP_NAME

MapByName

Specifies whether to map fields and columns by name or by position when transferring data between the data source IBM® Lotus Enterprise Integrator® (LEI) and Domino® Enterprise Connection Services (DECS).

Boolean

True (1)

LCTOKEN_ WRITEBACK

Writeback

Specifies whether the LCXUpdate or LCXRemove operation is a writeback operation.

Boolean

True (1)

LCTOKEN_ FIELDNAMES

FieldNames

Displays a text list of fields with which to perform an operation.

TextList

"EMPID, FNAME, LNAME"

LCTOKEN_ ORDERNAMES

OrderNames

Displays a text list of fields to order results by.

TextList

"LNAME, MGR"

LCTOKEN_ CONDITION

Condition

Specifies a DB2-specific syntax conditional clause used for select, keyed update, and remove operations. Must be of valid syntax.

Text

"EMPID = 1123"

LCTOKEN_ STAMPFIELD

StampField

Specifies a field name of timestamp field.

Text

"MODIFIED"

LCTOKEN_ BASESTAMP

BaseStamp

Specifies a minimum timestamp value to include in result sets.

Datetime

11/17/2000 12:00 AM

LCTOKEN_ MAXSTAMP

MaxStamp

Displays the current timestamp value. During a Select operation, this is set by the Connector to the current timestamp value.

Datetime

09/27/2000 01:38 PM

LCTOKEN_ TEXT_FORMAT

TextFormat

Specifies a DB2® character set other than NATIVE.

Text

"IBMCP932"

LCTOKEN_ PROCEDURE

Procedure

Specifies the stored procedure to execute for the LCXCall method.

Text

"DBINST1.PROC1"

LCTOKEN_ OWNER

Owner

Displays a result set.

Only objects owned by the owner name in this property are included in the result set

Text

"DBINST1"

LCTOKEN_ ALT_METADATA

AlternateMetadata

Affects the behavior of METADATA and FIELD catalog types, returning a list of objects of the alternate metadata type instead of the normal metadata type.

Boolean

True (1)

LCTOKEN_ RECORD_LIMIT

RecordLimit

Specifies the maximum number of records in the result set. Result sets produced should be limited to this many records. A value of zero (the default) indicates no limit.

Integer

10.00

LCTOKEN_ SCROLLABLE

Scrollable

Specfies whether or not fetch cursors will be scrollable in DB2®.

Note: Scrollable cursors are currently supported in LotusScript® and LCJava only. Scrollable cursors are disabled by default, and enabled by setting the connection property "SCROLLABLE" to True (1) in the script.

Boolean

True (1)

LCTOKEN_ POSITION

Position

Specifies the start position of a scrollable cursor.

Integer

1.00

CommitFrequency

Specifies the number of modification actions between commits. A value of zero causes a commit at disconnect; a value of one auto-commits after every action; any other value commits after that many data modification actions.

Integer

10.00

2.00

RollbackOnError

Specifies whether to roll back the current transaction at disconnect if the session is in an error state.

Boolean

True (1)

3.00

CreateMaxLogged

Specifies the maximum length of a CLOB/BLOB column to create when logging. This value is used when creating tables.

If, during metadata creation, the length is longer than this value, the option NOT LOGGED COMPACT is used.

A value of zero indicates no maximum, although unbounded columns are always created with this option.

Integer

128.00

4.00

NoJournal

Specifies whether the database contains non-journaled data. If so, the transaction isolation level is set to uncommitted read to permit SQL operations.

Boolean

False (0)

5.00

CreateInDatabase

Used to add "IN DATABASE <dbname>" to a CREATE TABLE query constructed for table creation.

Text

"DBINST1.EMP_TABLE2"

6.00

TraceSQL

Specifies that all SQL statements generated 1 during the execution of the activity be included in the activity's log.

Boolean

True (1)