DB2® Data Types
The following tables show the correspondences of DB2® to LotusScript® data types.
In DB2®, the data type pairs DOUBLE and FLOAT and NUMERIC and DECIMAL are synonymous, and only the first of each type synonym (DOUBLE and NUMERIC) is indicated in these tables.
- (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.
Data Type Considerations
The following considerations pertain to use of DB2® data types.
- When you use the DB2® BIGINT data type as a keyfield on a connection document, a precision loss error occurs when you initialize keys. The error also occurs if you select "Leave all/Leave selected RealTime fields in Documents" and one of the field values is a BIGINT. To avoid this error, use a different data type in these instances.
- The DB2® data type DATALINK and the Data Links Manager are not currently supported.
- The DB2® column used as the timestamp field in timestamp replication or timestamp polling must be of type TIMESTAMP, not DATE.
- DB2® allows the storage of the time value 12:00:00 AM as both 00:00:00 and 24:00:00. When transferring 24:00:00 from DB2®, Domino® Enterprise Connection Services (DECS) and Lotus Enterprise Integrator® (LEI) consider this time to be invalid. If 12:00:00 AM times are inserted through DB2®, and not through DECS or LEI, use 00:00:00 for 12:00:00 AM, not 24:00:00.
Execute
This table describes how the Execute method converts data types between LotusScript® Connector Extensions and DB2®.
DB2® Data Type |
Attribute |
Lotus® Connector (LC) Data Type |
---|---|---|
BIGINT |
Numeric |
|
SMALLINT |
Int |
|
INTEGER |
Int |
|
DOUBLE |
precision =15 |
Float |
NUMERIC |
prec-scale<=9, scale<=0 |
Int |
NUMERIC |
prec-scale<=19, scale<=4 |
Currency |
NUMERIC |
other |
Numeric |
DATE |
Datetime |
|
REAL |
precision =7 |
Numeric |
TIME |
Datetime |
|
TIMESTAMP |
Datetime |
|
CHAR |
(default) FOR BIT DATA |
Text (fixed length, bound <= 32766) Binary (BLOB format) (fixed length, bound <= 32766) |
VARCHAR |
(default) FOR BIT DATA |
Text (variable length, bound <= 32740) Binary (BLOB format) (variable length, bound <= 32740) |
LONG VARCHAR |
(default) FOR BIT DATA |
Text (variable length, bound <= 32740) Binary (BLOB format) (variable length, bound <= 32740) |
CLOB |
Text (variable length, bound <= 2GB) |
|
GRAPHIC |
Text (fixed length, bound <= 16383) |
|
VARGRAPHIC |
Text (variable length, bound <= 16383) |
|
LONG VARGRAPHIC |
Text (variable length, bound <= 32700) |
|
DBCLOB |
Text (variable length, bound <= 2GB) |
|
BLOB |
Binary (BLOB format) (variable length, bound <= 2GB) |
Fetch
This table describes how the Fetch method converts data types between LotusScript® Connector Extensions and DB2®.
Lotus® Connector (LC) Data Type |
Attribute |
DB2® Data Type |
---|---|---|
Int |
INTEGER, SMALLINT, DOUBLE (p), NUMERIC (p) |
|
Float |
INTEGER, SMALLINT, DOUBLE, NUMERIC (p) |
|
Currency |
INTEGER, SMALLINT, DOUBLE (p), NUMERIC (p) |
|
Numeric |
INTEGER (p), BIGINT, SMALLINT (p), DOUBLE (p), NUMERIC (p) |
|
Datetime |
TIMESTAMP (p), DATE, TIME |
|
Text (o) |
CHAR [FOR BIT DATA], VARCHAR [FOR BIT DATA], LONG VARCHAR [FOR BIT DATA], CLOB, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC, DBCLOB, BLOB |
|
Binary (o) |
BLOB |
CHAR [FOR BIT DATA], VARCHAR [FOR BIT DATA], LONG VARCHAR [FOR BIT DATA], CLOB, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC, DBCLOB, BLOB |
non-BLOB |
Invalid |
Insert/Update
This table describes how the Insert and Update methods convert data types between LotusScript® Connector Extensions and DB2®.
Lotus® Connector (LC) Data Type |
Attribute |
DB2® Data Type |
---|---|---|
Int |
INTEGER, SMALLINT (p), DOUBLE, NUMERIC (p) |
|
Float |
INTEGER (p), SMALLINT (p), DOUBLE, NUMERIC (p) |
|
Currency |
INTEGER (p), SMALLINT (p), DOUBLE (p), NUMERIC (p) |
|
Numeric |
INTEGER (p), BIGINT, SMALLINT (p), DOUBLE (p), NUMERIC (p) |
|
Datetime |
TIMESTAMP, DATE (p), TIME (p) |
|
Text |
CHAR [FOR BIT DATA] (o), VARCHAR [FOR BIT DATA] (o), LONG VARCHAR [FOR BIT DATA] (o), CLOB (o), GRAPHIC (o), VARGRAPHIC (o), LONG VARGRAPHIC (o), DBCLOB (o), BLOB (o) |
|
Binary |
any |
CHAR [FOR BIT DATA] (o), VARCHAR [FOR BIT DATA] (o), LONG VARCHAR [FOR BIT DATA] (o), CLOB (o), GRAPHIC (o), VARGRAPHIC (o), LONG VARGRAPHIC (o), DBCLOB (o), BLOB (o) |
number list |
INTEGER (p), BIGINT, SMALLINT (p), DOUBLE, NUMERIC (p) |
|
datetime list |
TIMESTAMP, DATE (p), TIME (p) |
Create
This table describes how the Create method converts data types between LotusScript® Connector Extensions and DB2®.
Lotus® Connector (LC) Data Type |
Attribute |
DB2® Data Type |
---|---|---|
Int |
INT, SMALLINT, or NUMERIC (prec, 0) |
|
Float |
DOUBLE or NUMERIC (prec, scale) |
|
Currency |
NUMERIC (19, 4) |
|
Numeric |
NUMERIC (prec, scale), BIGINT |
|
Datetime |
TIMESTAMP, DATE, or TIME |
|
Text |
CHAR (fixed,len<=254), VARCHAR (254<len<=4000), LONG VARCHAR (4000<len<=32700), or CLOB (length > 32700) |
|
Binary |
BLOB |
CHAR FOR BIT DATA (fixed,len<=254), VARCHAR FOR BIT DATA (254<len<=4000), LONG VARCHAR FOR BIT DATA (4000<len<=32700), or BLOB (length > 32700) |
composite |
CHAR (fixed,len<=254), VARCHAR (254<len<=4000), LONG VARCHAR (4000<len<=32700), or CLOB (length > 32700) |
|
number list |
DOUBLE |
|
datetime list |
TIMESTAMP |
|
text list |
CHAR (fixed,len<=254), VARCHAR (254<len<=4000), LONG VARCHAR (4000<len<=32700), or CLOB (length > 32700) |