Sybase Connector Properties

The following table defines the properties for the Lotus® Connector for Sybase.

Token

Name/Description

Type

LCTOKEN_SERVER

Server

Server name. Required.

Text

LCTOKEN_DATABASE

Database

Database name.

Text

LCTOKEN_USERID

User ID/name (Userid)

Used for logging in during connection

Text

LCTOKEN_PASSWORD

Password

Password -- used for logging in during connection

Text

LCTOKEN_METADATA

Metadata

Metadata object -- the source or target for data transfer operations. A form (Notes®), table (relational DB), or other data container

Text

LCTOKEN_INDEX

Index

Index name. A view (Notes®), index (relational DB), or other data index

Text

LCTOKEN_MAP_NAME

MapByName

Whether to map by name or position when transferring data between data source and target.

Boolean

LCTOKEN_WRITEBACK

Writeback

Whether to perform writeback or non-writeback operations.

Boolean

LCTOKEN_FIELDNAMES

FieldNames

Multi-value text list of fields to select -- used for Select operations

Text List

LCTOKEN_ORDERNAMES

OrderNames

Multi-value text list of fields to order results by -- it is used for Select operations

Text List

LCTOKEN_CONDITION

Condition

Connector-specific syntax conditional clause -- used for Select operations

Text

LCTOKEN_STAMPFIELD

StampField

Field name of timestamp field -- used for Select operations

Text

LCTOKEN_BASESTAMP

BaseStamp

Minimum timestamp value to include in results -- used for Select operations

Datetime

LCTOKEN_MAXSTAMP

MaxStamp

During a Select operations, set by the connector to the current timestamp value - set by Select operations

Datetime

LCTOKEN_PROCEDURE

Procedure

The stored procedure to execute for the Call method. Any returned result set is available.

Text

LCTOKEN_ OWNER

Owner

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

Text

LCTOKEN_ALT_METADATA

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

LCTOKEN_CONNECT_TIMEOUT

Maximum number of seconds to wait for a successful connection (the default value of zero indicates to use that connector's default settings).

Integer

LCTOKEN_RECORD_LIMIT

Result sets produced should be limited to this many records. A value of zero (the default) indicates no limit.

Integer

3.00

CreateShortBound

Whether to truncate bounded text and binary data during table creation. When used, all text and binary fields with a maximum length will be truncated to fit in a char/ varchar/binary/ varbinary column.

Boolean

4.00

CreateShortUnbound

Whether to truncate unbounded text and binary data during table creation. When used, all text and binary fields with no maximum length will be truncated to fit in a char/varchar/binary/ varbinary column.

Boolean

5.00

DisableCursor

Disable Sybase writeback cursors.

Boolean

6.00

ProcedureStatus

A Sybase stored procedure can either generate a result set or return a status code. When a non-zero code is returned, this may signal an error. The default behavior is to interpret the status as a 1-row, 1-column result set. Selecting this option interprets the status code separately, not as a result set (non-zero is error, and zero is success).

Boolean

7.00

TraceSQL

Select this option to include all SQL statements generated during the execution of the activity in the activity's log. This can be helpful when you need to troubleshoot the activity.

Boolean