The following tables list the default values that a column of a table
in a data source might have. A source table having columns with any of the
default values listed can be synchronized by the
DB2® Everyplace® Sync Server.
A table having columns with default values not listed in the table for the
data source cannot be synchronized by the
DB2 Everyplace Sync Server.
Note: If you are using the IBM® Toolbox for Java™ driver to connect to DB2 on AS/400®, your
table cannot have any columns with non-null default values.
Table 1. Supported DB2 default values| DB2 data type |
DB2 default value |
| BIGINT |
constant, NULL |
| BLOB |
NULL |
| CHAR(n) |
constant, NULL |
| DATE |
current date, NULL |
| DECIMAL(p,s) |
constant, NULL |
| DOUBLE |
constant, NULL |
| FLOAT |
constant, NULL |
| GRAPHIC(n) |
NULL |
| INTEGER |
constant, NULL |
| LONG VARCHAR |
constant, NULL |
| LONG VARCHAR FOR BIT DATA |
NULL |
| LONG VARGRAPHIC |
NULL |
| REAL |
constant, NULL |
| SMALLINT |
constant, NULL |
| TIME |
current time, NULL |
| TIMESTAMP |
current timestamp, NULL |
| VARCHAR(n) |
constant, NULL |
| VARCHAR(n) FOR BIT DATA |
NULL |
| VARGRAPHIC(n) |
NULL |
Table 2. Supported Informix default values| Informix® data type |
Informix default value |
| BLOB |
NULL |
| CHAR |
NULL |
| CHARACTER VARYING(m,r) |
NULL |
| DATE |
NULL |
| DATETIME HOUR TO SECOND |
NULL |
| DATETIME HOUR TO FRACTION |
NULL |
| DATETIME YEAR TO DAY |
NULL |
| DATETIME YEAR TO SECOND |
NULL |
| DATETIME YEAR TO FRACTION |
NULL |
| DATETIME YEAR TO FRACTION(5) |
NULL |
| DECIMAL(p,s) |
NULL |
| DOUBLE PRECISION |
NULL |
| FLOAT(n) |
NULL |
| INT8 |
NULL |
| INTEGER |
NULL |
| INTERVAL largest_qualifier(p) TO smallest_qualifier(s) |
NULL |
| LVARCHAR |
NULL |
| MONEY(p,s) |
NULL |
| NCHAR(n) |
NULL |
| NUMERIC(p,s) |
NULL |
| NVARCHAR(m) |
NULL |
| REAL |
NULL |
| SMALLFLOAT |
NULL |
| SMALLINT |
NULL |
| VARCHAR(m) |
NULL |
Table 3. Supported Oracle default values| Oracle data type |
Oracle default value |
| BLOB |
NULL |
| CHAR(n) |
constant, NULL |
| DATE |
SYSDATE, NULL |
| NUMBER(p,s) |
constant, NULL |
| RAW(n) |
NULL |
| TIMESTAMP |
NULL |
| VARCHAR2(n) |
constant, NULL |
Table 4. Supported Microsoft SQL Server default values| Microsoft® SQL Server data type |
Microsoft SQL Server default value |
| BIGINT |
constant, NULL |
| BIT |
constant, NULL |
| CHAR |
constant, NULL |
| DATETIME |
NULL |
| DECIMAL |
constant, NULL |
| FLOAT |
constant, NULL |
| INTEGER |
constant, NULL |
| MONEY |
constant, NULL |
| NCHAR |
constant, NULL |
| NUMERIC |
constant, NULL |
| NVARCHAR |
constant, NULL |
| REAL |
constant, NULL |
| SMALLDATETIME |
NULL |
| SMALLINT |
constant, NULL |
| SMALLMONEY |
constant, NULL |
| TINYINT |
constant, NULL |
| VARBINARY or VARCHAR(MAX) |
NULL |
| VARCHAR |
constant, NULL |
Everyplace 9.1.1 for Lotus Expeditor 6.1.1
Last updated: July, 2007