|
Home > Archive > SQL Anywhere database replication > July 2005 > DEFAULT TIMESTAMP and replication using SQLRemote
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DEFAULT TIMESTAMP and replication using SQLRemote
|
|
| Edgard L. Riba 2005-07-09, 3:23 am |
| Hi,
Using ASA9.
When a table is used in replication, and has a DEFAULT TIMESTAMP column,
does this column changes when the record replicates?
Let me try to be clearer. A DEFAULT TIMESTAMP column changes whenever the
record is updated to reflect the time of the update. Let say that a row on
a table at "Remote-Site-A" gets updated at 7:00AM. The timestamp column
gets this time.
Let's then say that the row replicates to another server "B" at 9:00AM.
Will the timestamp column for the given row, at server "B" contain 7:00AM or
9:00AM?
Best regards,
Edgard L. Riba
| |
| Rob Waywell 2005-07-11, 9:23 am |
| I believe this has already been answered on the general newsgroup.
Default actions only occur if a value for the column is not provided at the
time of the operation. Since dbremote is replicating the value from the log
file, it will include the value that was set for the timestamp column at the
sending node and this will override the default when the operation is
applied at the receiving node.
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"Edgard L. Riba" <elriba at rimith dot com> wrote in message
news:42cedf12@forums
-1-dub...
> Hi,
>
> Using ASA9.
>
> When a table is used in replication, and has a DEFAULT TIMESTAMP column,
> does this column changes when the record replicates?
>
> Let me try to be clearer. A DEFAULT TIMESTAMP column changes whenever
> the record is updated to reflect the time of the update. Let say that a
> row on a table at "Remote-Site-A" gets updated at 7:00AM. The timestamp
> column gets this time.
>
> Let's then say that the row replicates to another server "B" at 9:00AM.
>
> Will the timestamp column for the given row, at server "B" contain 7:00AM
> or 9:00AM?
>
> Best regards,
> Edgard L. Riba
>
>
|
|
|
|
|