Skip to Content
0
Former Member
May 01, 2013 at 04:35 PM

using 'numeric(nn,n)' into replication definition is rejected

78 Views

In the next example, the replication definition is always rejected because i am using a ' numeric 15,0)' column type...

I do not found the good syntax ???

create table TB_Primary (col1 numeric(15,0) primary key, col2 varchar(100))

. . .

create table TB_Replicate (col1 numeric(15,0) primary key, col2 varchar(100))

create replication definition trd_TB_001

with primary at SYBPRIMARY.DB_Primary

with primary table named 'TB_Primary'

with replicate table named 'TB_Replicate'

(col1 numeric(15,0), col2 varchar(100))

primary key col1

replicate all columns