2882888 - Oracle to SAP IQ Replication Setup for timestamp columns - SRS

create replication definition mytable_rd
with primary at ora.db
with primary table named 'mytable'
with replicate table named 'NAME'.'nytable'
(
ORDER_DATE TIMESTAMP,
SRC_ID VARCHAR(64),
ORDER_ID VARCHAR(64),
MYSYMBOL VARCHAR(40),
SYMBOL VARCHAR(40),
FORCE VARCHAR(24),
ID FLOAT,
USER VARCHAR(30),
TIME TIMESTAMP,
USER2 VARCHAR(30),
TIME2 TIMESTAMP
)
primary key("ORDER_DATE", "ORDER_ID", "SYMBOL")
send standby replication definition columns
go
Msg 149, Level 12, State 0:
Server 'SERVER':
There is more than one timestamp column in the column list.

• SAP Replication Server (SRS) (all versions)
• SAP Replication Server Option (RSO) for Oracle 15.7.1

KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To