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


HEI	Notes®
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)