Support for bigdatetime and bigtime Datatypes

Replication Server supports replication of the bigdatetime and bigtime datatypes included with Adaptive Server.

You can replicate these datatypes to replicate databases and warm standby databases by specifying the datatypes in replication definitions, function replication definitions, and subscriptions.

bigdatetime and bigtime allow Adaptive Server to store data and time data up to microsecond precision. bigdatetime corresponds to the TIMESTAMP datatype, and bigtime corresponds to the TIME datatype in Sybase IQ.

See Replication Server Reference Manual > Topics > Datatypes > Date/time, and date and time Datatypes for descriptions of the datatypes.

You can use rs_helprep to display information about bigdatetime and bigtime.

rs_subcmp supports bigdatetime and bigtime.

See the Replication Server Reference Manual for descriptions of the commands.

These examples show how to use bigdatetime and bigtime in a replication definition, a function replication definition, and a subscription.

In these examples:

PDS – primary data server
pdb1 – primary database
RDS – replicate data server
rdb1 – replicate database
tb1 – table
col1, col2, col3 – columns
rep1 – replication definition
func1 – function replication definition
sub1 – subscription

Replication Definition

create replication definition rep1
with primary at PDS.pdb1
with all tables named tb1
(col1 int, col2 bigdatetime, col3 bigtime)
primary key (col1)

Function Replication Definition

create function replication definition func1
with primary at PDS.pdb1
(@par1 int, @par2 bigdatetime, @par3 bigtime)
searchable parameters (@par1)

Subscription

create subscription sub1 for rep1
with replicate at RDS.rdb1
where col3 = ‘14:20:00.010101’
without materialization