Notes® Data Types

The following tables show the correspondences of Notes® to HCL Enterprise Integrator (HEI) data types for various types of activities. The following notes apply to the tables as follows:

(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 Notes® Connection Option "Maximum Length for Text Data" alters the default boundary of 64996 for HEI text.

The Notes® Connection Option "Translate Multivalue Types to Text" makes multiple-value Text, Data, and Time look like single-value Text.

HEI evaluates the absence of a field in a Notes® database as a NULL.

Note: For more information on the organization of these tables, see the section entitled "Note on Connection Data Type Conversion Tables" in Chapter 3.

Execute

Notes®

HEI
Number

Single-value -- Notes® Number field contains a single value

Float

Allow multiple values

Binary (number list format, variable length, bound = 64996)

Time

Single-value

Datetime

Allow multiple values

Binary (datetime list format, variable length, bound = 64996)

Keywords

Text (variable length, bound = 64996)

Names

Text (variable length, bound = 64996)

Author Names

Text (variable length, bound = 64996)

Reader Names

Text (variable length, bound = 64996)

Text

Single value

Text (variable length, bound = 64996)

Allow multiple values

Binary (text list format, variable length, bound = 64996)

Rich Text

Binary (composite format, variable length, unbounded)

Fetch

HEI

Notes®

Int

Number (p, o)

Float

Number

Currency

Number (p, o)

Numeric

Number (p, o)

Datetime

Time

Text (o)

Text, Rich Text, Formula

Binary (o)

BLOB

Text, Number allow multi-values, Time allow multi-values, Rich Text, Formula

composite

Text (single-value), Rich Text

number list

Number, Text (single-value)

datetime list

Time, Text (single-value)

text list

Text

Insert/Update

HEI

Notes®

Int

Number

Float

Number

Currency

Number (p)

Numeric

Number (p)

Datetime

Time

Text

Text, Rich Text, Formula

Binary

BLOB

Text (o), Number (allow multiple values) (o), Time (allow multiple values) (o), Rich Text, Formula (o)

composite

Date from Notes® Rich Text field

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

Int

Number (single-value)

Float

Number (single-value)

Currency

Number (single-value)

Numeric

Number (single-value)

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)