Sybase Connector Properties
The following table defines the properties for the 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 |