Skip to Content
0
Former Member
May 06, 2013 at 06:29 PM

Reserve word column name stopping replication 15.6 ESD2

142 Views

I upgraded from 15.6 to 15.6 ESD2 and moved to a new machine (new rep config also). I have a table that contains a reserved word [default] as column name and it is stopping my DSI to the warm standby server (no repdefs). Do I just need to alter the conection to turn on quoted identifiers? Sybase is telling me I have to create a repdef, but I never had one before and this table has been in the DB since 2010.

create table test (

[default] char(1) NULL,

col2 char(10) NULL,

.

.

.)

Rep Server now stops DSI and after dumping transaction we see:

delete from dbo.ZipSp_new where zip='37882' and
city='TOWNS' and county='BOUT' and st='TN' and uspscty='TOWNS' and
cntyfips='409' and cntydef=' ' and default=' ' and gecode='4700970' and
inout='B'

Rep server kills DSI with syntax error.

Message from server: Message: 156, State 2, Severity 15 -- 'Incorrect syntax near the keyword 'default'.