When the source is DB2 and the target is MS SQL Server, Sybase, or Sybase
SQL Anywhere, the following restrictions and conversions are performed:
Table 38. Data Type Conversion: DB2 to MS SQL Server, Sybase, or SQL Anywhere
| DB2 for OS/390 SOURCE | MS SQL SERVER, SYBASE, OR SQL ANYWHERE TARGET | Changes after Create Nickname | ||
|---|---|---|---|---|
| COLTYPE | LENGTH | SCALE | ||
| CHAR (n) FOR BIT DATA | BINARY(n) | CHAR 1 |
|
|
| VARCHAR(n) FOR BIT DATA(N) | VARBINARY(n) or BINARY(n) |
|
|
|
| CHAR(n) | CHAR(n) |
|
|
|
| VARCHAR(<256) | VARCHAR2(n) or VARCHAR(n) |
|
|
|
| VARCHAR(<256) | TEXT |
|
|
|
| GRAPHIC(n) 2 | ? |
|
|
|
| VARGRAPHIC(n) 2 | ? |
|
|
|
| LONG VARCHAR 2 | ? |
|
|
|
| DATE | DATETIME or DATE | DATE | 4 |
|
| TIMESTAMP | DATETIME or DATESTAMP |
|
|
|
| TIME | DATETIME or TIME | TIME | 3 |
|
| SMALLINT | SMALLINT |
|
|
|
| INTEGER | INT |
|
|
|
| DECIMAL(n,m) | DECIMAL(n,m) |
|
|
|
| FLOAT | FLOAT |
|
|
|
|
1DJRA creates the target table in MS SQL Server with data type "binary." The DataJoiner nickname is created with COLTYPE of VARCHAR. DJRA updates the COLTYPE to CHAR. 2These DB2 for OS/390 data types have not been tested.
|