Show TOC

Configuration of Datatype Mapping for DDL ReplicationLocate this document in the navigation structure

Replication Server allows you to define mapping for the datatypes in the DDL commands when replicating and initializing replicate tables during materialization.

By adding the support of Microsoft SQL Server and IBM DB2 UDB as primary databases, the syntax is enhanced with:

Syntax
configure replication server set ddl_datatype_map from {ORA | MSSQL | UDB}.{<pdatatype> | <pdatatype(n)> | <pdatatype(precision,scale)> | } to {HDB}.{NULL | <rdatatype> | <rdatatype>[multi]| <rdatatype(n)> | <rdatatype(precision,scale)>}
The datatype for the primary database in the mapping should match the datatype stored in the database system except for the datatypes listed in the following table:
Table 1: Special Cases in DDL Datatype Mapping
Primary Database Primary Table Datatype Primary Datatype in DDL Datatype Mapping Comments
Oracle Integer NUMBER(38,0)  
Binary Float Binary_Float(-2147483647)  
Timestamp(n) Timestamp(n) The n parameter is defined in the column DATA_SCALE in the table USER_TAB_COLUMNS
Nchar(n)/nvarchar2(n) Nchar(n)/nvarchar2(n)  

Float

float(126,0)

Binary_float

BINARY_FLOAT(-1,-1)

IBM DB2 UDB

Time(n)/Timestamp(n)

Time(n)/Timestamp(n)

The n parameter matches the scale provided in the table SYSCOLUMNS

Large Objects

Large Objects(n)

The n parameter is defined in column LongLength in the table SYSCOLUMNS

Char(10) for bit data

CHARACTERFORBITDATA(10)

varchar(1000) for bit data

VARCHARFORBITDATA(1000)

long varchar for bit data

LONG VARCHARFORBITDATA(32700)

Microsoft SQL Server

Varchar(max)

Varchar(2147483647)

Varbinary(max)

Varbinary(2147483647)

Nvarchar(max)

Nvarchar(1073741823)

Text

Text(2147483647)

Image

Image(2147483647)

Ntext

Ntext(1073741823)

Nchar(n)/nvarchar(n)

Nchar(n)/nvarchar(n)

Time

Time(n)

The n parameter is defined in column precision in the database system table sys.columns

Timestamp

Timestamp

Float

float(126,0)

  

uniqueidentifier

uniqueidentifier(36)

Varchar(max)

"Varchar(max)"(2147483647)

Varbinary(max)

"Varbinary(max)"(2147483647)

Nvarchar(max)

"Nvarchar(max)"(1073741823)