Lotus® Connector for Text Data Types
The following tables show the correspondences of Lotus® Connector for Text data types to IBM® Lotus Enterprise Integrator® (LEI) data types for various types of activity.
- (p) -- Indicates that if Allow Precision Loss is not enabled, then an error will be generated on the type match. Allowing precision loss is the default.
- (o) -- Indicates that overflow checking will be performed when data is being transferred. If an overflow occurs and Truncate Data When Necessary is enabled, then the data is truncated; if not an error is generated.
- Text, Number, or Time indicates single value unless otherwise specified.
- The Lotus® Connector for Text option Maximum Length for Text Data alters the default bound of 64996 for LEI Text.
Execute
The Execute data types are listed as follows.
Text |
Lotus® Connector API |
---|---|
Number (suffix .n for implied decimal) |
single value |
Number (with defined SEPARATOR string) |
allow multivalues |
DateTime |
single value |
Datetime (with defined SEPARATOR string) |
allow multivalues |
Text |
single value |
Text (with defined SEPARATOR string) |
allow multivalues |
Rich Text |
|
Numeric |
|
Currency |
Fetch
The Fetch data types are listed as follows.
Lotus® Connector API |
Text |
|
---|---|---|
Int |
Number (p, o) |
|
Float |
Number |
|
Currency |
Currency |
|
Numeric |
Numeric |
|
Datetime |
Datetime |
|
Text (o) |
Text, Rich Text, Formula |
|
Binary (o) |
BLOB |
Text, Number allow multiple values, Time allow multiple values, Rich Text |
composite |
Text (single value), Rich Text |
|
number list |
Number, Text (single value) |
|
datetime list |
Time, Text (single value) |
|
text list |
Text |
Insert
The Insert data types are listed as follows.
Lotus® Connector API |
Text |
|
---|---|---|
Int |
Number |
|
Float |
Number |
|
Currency |
Currency |
|
Numeric |
Numeric |
|
Datetime |
Datetime |
|
Text |
Text, Rich Text |
|
Binary |
BLOB |
Text (o), Number (allow multiple values) (o), Time (allow multiple values) (o), Rich Text |
composite |
Text (single value) (o), Rich Text |
|
number list |
Number (o), Text (single value) (o) |
|
datetime list |
Time (o), Text (single value) (o) |
|
text list |
Text (o) |
Create
The Create data types are listed as follows.
Lotus® Connector API |
Text |
|
---|---|---|
Int |
Number (single value) |
|
Float |
Number (single value) |
|
Currency |
Currency |
|
Numeric |
Numeric |
|
Datetime |
Time (single value) |
|
Text |
bounded |
Text (single value) |
unbounded |
Rich Text |
|
Binary |
BLOB |
Text (single value) |
composite |
Rich Text |
|
number list |
Number (allow multiple values) |
|
datetime list |
Time (allow multiple values) |
|
text list |
Text (allow multiple values) |