DB2® Connector Properties
This table defines the properties for the 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 ®HCL Enterprise Integrator (HEI) 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 |
"HCLCP932" |
| 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) |