Skip to Content
0
Former Member
Sep 20, 2014 at 03:36 PM

How to enable multi-statement replication like select into in SAP Replication server

589 Views

Hi All,

Currently I am worling on replication of non logged operation using SAP Replication Server.My source and target databases both are Sybase ASE 15.7. I created a normal stored procedure having non logged operation like :

create procedure proc1

as

select * into tab2 from tab1

I have created database replication definition using following command :

create database replication definition def1

with primary at dewdfgwp01694.src

replicate DDL

replicate functions

replicate transactions

replicate tables

and created subscription as well

After marking the procedure using sp_setrepproc proc1,'function', I started the repagent (sp_start_rep_agent src)

But after marking the procedure I am unable to execute the procedure and having the error :

SELECT INTO command not allowed within multi statement transactions

Sybase error code=226

Can anyone please guide me in this situation

FYI : I have executed all three commands in primary database :

sp_dboption src,'select into/bulkcopy/pllsort',true;

sp_dboption src,'ddl in tran',true;

sp_dboption src,'full logging for all',true